Home Forums SQL Server 2005 Administering How to allow developers to ''see'' proc text in a protected db environment RE: How to allow developers to ''see'' proc text in a protected db environment

  • All you have to do is get into the database you want your users (dev team) can use the sp_helptext proc and select properties Option

    You will see the permissions tab on your left, so, on the rigth pane on (User or Roles Option) select your user (if you have an AD Group for your dev team as a single login is better)

    In the down Pane scroll down and select the "View Definition" Option select Grant and then Select OK

    And is Done!