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