Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL/Server   (RSS)
Sorry, but there are no more tags available to filter with.

Granting EXECUTE privilege on group of stored procedures to a specified user

CREATE proc grants(@procs varchar(100),@user varchar(100)) as declare curse cursor for select name from sysobjects where type='P' and name like @procs OPEN CURSE declare @proc varchar(100) declare @stmt nvarchar(200) fetch next from curse into @proc while
Posted by samar | 0 Comments
Filed under:
 
Page view tracker