GRANT permission to all stored procedures
If you need to grant a specified permission to all stored prcedures you can execute the following script
DECLARE @User sysname
SET @User = '<USER>' SELECT 'GRANT EXECUTE ON ' + name + ' TO ' + @User
FROM sysobjects
WHERE type = 'P' AND category = 0 After that you just need to grab the output of this script and execute it.