Grant Execute Permission To All Stored Procedures

An easy way to grant execute permissions for a user to all stored procedures?

EXEC sp_addrolemember 'db_datareader', 'YourNewLogin'
GO
GRANT EXECUTE ON SCHEMA::dbo TO "YourNewLogin"
GO
EXECUTE AS user = '"YourLogin"'
SELECT 'Test 1'
EXECUTE YourSP
REVERT
GO
SELECT 'Test 2'
EXECUTE YourSP
GO
REVOKE EXECUTE ON SCHEMA::dbo TO ""YourLogin""
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License