GRANT EXECUTE ON Stored Procedure in MSSQL SERVER 2005

• Saurabh S Kothari

  SSC Enthusiast

  Points: 173

  More actions

  June 6, 2008 at 12:10 am

  #183179

  select 'GRANT EXECUTE ON [dbo].'+ name + ' TO [domain\NTAccount]' +char (10) +'go' +Char (10) from sys.sysobjects where type='P' order by name asc