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 2005 Forums
 SQL Server Administration (2005)
 view all users defined stored procedures

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-04-07 : 11:57:31
Hi

How to grant permissions to active directory security group to see all user defined stored procedures in all databases in sql server 2005.

Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-07 : 12:03:10
GRANT VIEW DEFINITION to [domain\group]

this will let 'em see views and SPs too
Go to Top of Page
   

- Advertisement -