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
WHERE type = 'P' AND category = 0
After that you just need to grab the output of this script and execute it.
Imagine you have file saved in a database. Then you have an aspx page that gets that page and sends it back to the user.
If you just simply use Response.BinaryWrite you get the browser's download dialog box and the file's name will be the aspx page's name. If you want to force the original file name you have to add an header to the response like this: