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]
2 Responses
Greetings! Very helpful advice in this particular article! It is the little changes that make the most important changes. Thanks for sharing!
Thanks for your blog, nice to read. Do not stop.