Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 A Permission to view permissions?

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-05-23 : 11:53:40
We need the ability to view stored procedures and view permissions on the stored procedures, but not be allowed to modify the Stored Procedures.

Currently we have only the permission to view the stored procedures but not the ability to view the permissions.

I believe we have View Definition. Does the View Definition not give the permission to check the permissions? Is there a way to have the ability to view permissions but not be able to modifiy the stored procedures.
   

- Advertisement -