DECLARE procs CURSOR FOR SELECT [name]
FROM sys.objects
WHERE type IN('p','AF','FN')
DECLARE @name AS VARCHAR(250)
DECLARE @stmt AS VARCHAR(1000)
OPEN procs
FETCH NEXT FROM procs INTO @name
WHILE @@FETCH_STATUS=0
BEGIN
SET @stmt='GRANT EXECUTE ON '+@name+' TO [USERNAME]'
EXEC(@stmt)
PRINT @stmt
FETCH NEXT FROM procs INTO @name
END
CLOSE procs
DEALLOCATE procs
No comments:
Post a Comment