SQL Server database roles

Question

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?

Answer 1

GRANT EXEC ON SCHEMA::dbo

You can substitue dbo for your particular setup

Answer 2

You have to roll your own.

CREATE ROLE db_executor;
GRANT EXECUTE TO db_executor;
EXEC sp_addrolemember 'db_executor', 'username';