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
Posted Friday, June 6, 2008 12:10 AM


Group: General Forum Members
Last Login: Tuesday, November 17, 2015 3:40 AM
Points: 21, Visits: 151
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