SQLUSA

Microsoft SQL Server 2000 Best Practices

How to grant execute permission on all sprocs?

 

Execute the following script generator query in Query Editor after setting the results to TEXT mode. Paste the resulting script back to the query window for deployment execution:

 

select 'grant execute on '''+name+''' to RoleX'''+char(10)+'go'
from sysobjects where type = 'P' order by name


American Standard in SQL Server Training
 
SQLUSA.com Home Page