Access to view procedure

• M&M

  SSC-Insane

  Points: 21700

  More actions

  June 1, 2010 at 5:21 pm

  #141263

  I am trying to provide a login access to view the stored procedure.

  That login could query syscomments object present in the database.

  Please let me know the process for doing it. Database reader role is useful for the tables etc.

  M&M

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  June 1, 2010 at 5:33 pm

  #1175047

  Create a role for this, then create VIEW DEFINITION rights to the role. Add the login to the role.

  http://technet.microsoft.com/en-us/library/ms175808.aspx