Grant Execute All Stored Procedures

Here I have tried to explain how we can provide permission to execute all the stored procedure in particular database. In SQL Server 2000 has fixed database roles such as db_datareader and db_datawriter that allow a user read or write access respectively to all the table is a database, no such role exists for the execution of stored procedures (a db_executor role if you will). Continue reading