I am Dale Hayter, a Microsoft and VMware certified Technical Consultant.

My blog has been built up over the years from my experience of working on an IT helpdesk and also from being out on-site.

© Blackforce

SQL – Grant execute to all stored procedures

If you want to grant some users the execute rights on all stored procedures under a database in SQL. Use the script below.

Now map your users / groups to this new role.