Sql Server–Execute Permissions

One way to provide users execute permissions on a database: (works in Sql Server 2005 and above)

Create a role and grant it execute permissions. Then add your user to that role.

/* CREATE A NEW ROLE */
CREATE ROLE db_executor

/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor