Advanced Search

Return to Snippet

Revision: 2913
at May 6, 2007 14:47 by rengber
Initial Code 
DECLARE @User varchar(50)
SELECT @User = 'UserOrRole'

SELECT
'GRANT EXEC ON ' + name + ' TO ' + @User
FROM
sysobjects
WHERE
type = 'P'
AND category = 0
Initial URL 
http://www.geekzilla.co.uk/View2356DC3A-9F53-4A95-9849-C4518B8E1F92.htm
Initial Description 









Initial Title





Script to Create a Script Granting EXECUTE to all Stored Procs in a DB









Initial Tags





sql, script, security









Initial Language





SQL