Built-in database role in SQL Server 2005 to permit execution of stored procedures?
Solution 1
Take a look at this article. It may provide you an interesting idea to do this quickly.
Code used in that article:
/* Create a new role for executing stored procedures */
CREATE ROLE db_executor
/* Grant stored procedure execute rights to the role */
GRANT EXECUTE TO db_executor
/* Add a user to the db_executor role */
EXEC sp_addrolemember 'db_executor', 'AccountName'
Solution 2
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
Now, if you restart SQL Server Management Studio, when you click on the "User Mapping" page in the Security->Logins section, you'll see "db_executor" appear in the roles list. Just add the user or you can do it manually:
EXEC sp_addrolemember 'db_executor', 'AccountName'
Solution 3
No, I don't believe that there is a database or server role - you have to grant the execute permission granularly to the user for the relevant stored procedures.
frankadelic
Updated on June 14, 2022Comments
-
frankadelic almost 2 years
In SQL Server 2005, there are built in roles:
db_datareader
db_datawriter
etc.
Is there any role that lets a user execute an stored proc?
I don't want to use db_owner, because that will permit deletion and updates, which I don't need. The only permissions I need are:
SELECT
EXECUTE