Take the 2-minute tour ×

As I understand it, Users assigned to the db_datareader role have the rights to read all tables in the database and those assigned to db_datawriter can update all tables.

Is there a database role that gives a user rights to execute all stored procedures?

share|improve this question

2 Answers 2

up vote 8 down vote accepted

You have to roll your own.

CREATE ROLE db_executor;
GRANT EXECUTE TO db_executor;
EXEC sp_addrolemember 'db_executor', 'username';
share|improve this answer
Not since SQL Server 2005 if you use permission on the schema –  gbn Jan 11 '12 at 21:33
@Joe: After I create the db-executor role, i will then have to grant that role permission to execute all stored procedures and every time I create a new SP, I'll have to modify the role to add exec rights to the new proc, right? –  ChadD Jan 11 '12 at 22:29

You can substitue dbo for your particular setup

share|improve this answer

Your Answer


