Microsoft SQL Server 2005 :Grant Execute Stored Procedure to USER
/* 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', ' Username '