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.
2008-06-08
1,873 reads
Grant Permission to Specific objects(e.g. SP's)
Select 'GRANT EXECUTE ON '+name+' TO Maninder' from sysobjects Where type='P' and Category='0'
Related content
Search for a String in all Stored Procedures and beyond?
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,331 reads
2008-07-29 (first published: 2008-06-08)
1,261 reads