Post reply

Protecting a Query from Users

  • July 9, 2009 at 7:28 am

    #223429

    I create SQL queries that a number of people use, and sure enough it seems that every so often a comma gets added, or code goes missing. Is there a way to 'lock' a query from this sort of manipulation? Unfortunately some of the queries require the user to input information - so I am not sure this is possible.

    As an alternative, I may just create password protected word documents of the queries as back up.

  • July 9, 2009 at 7:30 am

    #1022348

    Are the queries in stored procedures? If yes, then just deny the updating of those procedures to the users in question, and leave them only to the DBA, or admin group?

    Does that help, or I misunderstood you?

    Cheers,

    J-F

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply