/ Published in: SQL

Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
DECLARE @USER VARCHAR(50) SELECT @USER = 'UserOrRole' SELECT 'GRANT EXEC ON ' + name + ' TO ' + @USER FROM sysobjects WHERE TYPE = 'P' AND category = 0
URL: http://www.geekzilla.co.uk/View2356DC3A-9F53-4A95-9849-C4518B8E1F92.htm
Comments
