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)
 alter procedure rights

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2007-07-05 : 05:11:51
Hi

How can I set alter procedure rights for all procedures in a database for one user?

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-05 : 10:05:42
Try binding with schemata, the only problem will be that there are also rights to purge or execute them for that person.

Need an SQL consultant?
check www.veeningsengineering.nl
Go to Top of Page
   

- Advertisement -