Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server 2005 Stored Procedure Permissions Expand / Collapse
Author
Message
Posted Tuesday, October 19, 2010 11:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 4, 2014 4:02 AM
Points: 26, Visits: 184
-- Create a new role
CREATE ROLE SP_Fn_executor

-- Grant execute to the created role
GRANT EXECUTE TO SP_Fn_executor


The above statement would create a role and grant execute permission on all existing stored procedures and scalar functions.
And as when we create new ones the permission would automatically be given to the Role.
Post #1007463
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse