Allow Execution of all Stored Procedures in a Schema

Posted 03/16/2018 8:06 AM by Corey Klass

Older versions of SQL Server did not have a role that allowed execution of all stored procedures. You can get around this by granting EXECUTE on an entire schema:

GRANT EXECUTE ON SCHEMA :: dbo TO [username]