Post reply

How to allow developers to ''see'' proc text in a protected db environment

  • April 9, 2010 at 9:50 am

    #1149233

    "View Definition" permission should work.

    - Satish

  • July 23, 2011 at 11:06 am

    #1357433

    Were you ever able to figure out how to let them VIEW (only) the procs?

    We have migrated from SQL 2000 to SQL2008 they both have the datareader role but in 2000 you can see the procs, but not in 2008.

    Please let me know what you did to get this working.

    Thanks in advance

    Susan

  • July 24, 2011 at 7:34 pm

    #1357587

    Granting view definition on the specific procs and funcs will satisfy the need. With reader only, you get access to tables, but not procs and funcs.

    I dont want them to be owners either. Too much control.

    I have done thus recently in my 2008 systems.

  • May 5, 2016 at 12:30 pm

    #1876946

    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!

Viewing 4 posts - 16 through 18 (of 18 total)

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