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.
