| 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 |
|