Post reply

Permissions issue

  • May 15, 2006 at 7:31 am

    #93912

    The developers here need to be able to view the SPs in SQL studio but not alter them. They also need write permissions on the tables. They are in a windows group which has a sql login. It appears i cant allow them to see SP code without making them ddl admin. There must be a way to do this. Any help would be greatly appreciated.

    Thanks,

    Jules.

    www.sql-library.com[/url]

  • May 15, 2006 at 3:17 pm

    #638021

    In properties of the users or role, select securables, then select "Specific Objects" or "All objects of types...", select stored procedures, then select the sp you want them to be able to view, then grant "View Definition".

  • May 18, 2006 at 2:42 am

    #638654

    Thanks that works great.

    www.sql-library.com[/url]

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

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