Thursday, May 03, 2012

Grant execute perms on all SPROCS to a user

Recently we had a problem getting grant permissions going on all sprocs in a db we'd deployed.

Please see the brilliant 'The Code Project' article by Sumit Amar with the solution:

http://www.codeproject.com/Articles/5860/Grant-Execute-on-all-procedures-to-a-user

Fixes to common .NET problems, as well as information on .NET features and solutions to common problems that are not language-specific.

Fixes to common .NET problems, as well as information on .NET features and solutions to common problems that are not language-specific.

Z