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

GRANT EXECUTE ON Stored Procedure in MSSQL SERVER 2005 Expand / Collapse
Author
Message
Posted Friday, June 6, 2008 12:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 1, 2013 6:46 PM
Points: 21, Visits: 144
select 'GRANT EXECUTE ON [dbo].'+ name + ' TO [domain\NTAccount]' +char (10) +'go' +Char (10) from sys.sysobjects where type='P' order by name asc
Post #512698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse