Post reply

Granting access to see User Stored Procedures

  • November 5, 2008 at 8:47 am

    #201146

    In SQL 2005 we want to grant our developers the abillity to view user stored procedures in production. I do not want them to be able to execute or modify them, just be able to view them for the purpose of validating the code. At this time the developers in question have data reader access only to the databases in question.

  • November 5, 2008 at 9:21 am

    #894339

    Try granting VIEW DEFINITION permission to the users in the database.

    Greg

  • November 5, 2008 at 11:54 am

    #894459

    Thanks for pointing me in the right direction. I was able to do exactly what I wanted.

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

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