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'


2 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *