Cacher is the code snippet organizer for pro developers

use INSERTDATABASENAWME HERE                    
SELECT 'GRANT EXECUTE ON ' + NAME + ' TO rfadmin;'
FROM SYSOBJECTS 
WHERE TYPE = 'P'
AND LEFT(NAME,2) <> 'sp' -- system procs 
AND LEFT(NAME,2) <> 'dt' -- VSS procs
AND LEFT(NAME,2) <> 'xt' -- other system procs
order by name;