How to grant exec rights to all stored procedures in Microsoft SQL Server 2005
Users are in our case always a member of some role. The role is given exec stored procedure rights and db_datareader, db_datawriter rights. Users in the role “TestRole” can select, insert, update, delete data and