Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Friday, June 6, 2008 12:10 AM


Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 21, Visits: 167
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