Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Script to grant exec permission to all sps in a db RE: Script to grant exec permission to all sps in a db

  • December 13, 2010 at 2:09 pm

    #1261937

    Short Way for SQL Server 2008 and SQL Server 2008 R2:

    declare @strSQL varchar(max)

    set @strSQL ='';

    select @strSQL = @strSQL + ' grant exec on ' + name + ' to User1 ;' from sys.procedures

    exec (@strSQL)

    MS SQL Server DBA
    www.mehmetguzel.net