Grant execute on all stored procedures

The following command effectively gives the user permission to execute ALL stored procedures in the database:

-- create a custom database role
CREATE ROLE db_executor


-- grant EXECUTE permission
GRANT EXECUTE TO db_executor

-- add security account to the role
exec sp_addrolemember 'db_executor', 'YourSecurityAccount'
[/code]