Technical Article

Grant Permission to Specific objects(e.g. SP's)

,

This Code Helps you to GRANT Various Permissions to Specific TYPE Objects in a Database.

you can expand this to include other Databases or all databases in a SQl Server instance.

Select 'GRANT EXECUTE ON '+name+' TO Maninder'
from sysobjects
Where type='P'
and Category='0'

Rate

3.67 (3)

You rated this post out of 5. Change rating

Share

Share

Rate

3.67 (3)

You rated this post out of 5. Change rating