Technical Article

Script to Generate Execution Permission to all Sprocs

,

This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.

Stored Procedures
-------------------
Select 'Grant Execute on ' + Name + ' To <user1,user2> ' 
+ Char(13) + Char(10) + 'GO' + Char(13) + Char(10)
From Sysobjects 
Where Xtype = 'P'

Tables
-----------------
Select 'Grant SELECT,INSERT,UPDATE on ' + Name + ' To <user1,user2> ' 
+ Char(13) + Char(10) + 'GO' + Char(13) + Char(10)
From Sysobjects 
Where Xtype = 'U'

Rate

3 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

3 (1)

You rated this post out of 5. Change rating