Grant Execute Permissions to All Procedures

Use master
go
/*  
This procedure grants Execute permissions to all procedures on a database to the role desired.  
The default role is Execute_storedprocedure  
*/  
CREATE procedure sp_grant_permissions_proc @role varchar(100)='Execute_StoredProcedure' as  
declare curname cursor for select name,user_name(uid) from sysobjects where xtype = 'P'  
declare @procname varchar(100)  
declare @username varchar(100)  
open curname  
fetch next from curname into @procname, @username  
while @@fetch_status = 0  
begin  
declare @sql varchar(300)  
set @sql = 'grant execute on ' + @username + '.[' + @procname + '] to Execute_Storedprocedure'  
exec(@sql)  
fetch next from curname into @procname, @username  
end  
close curname  
deallocate curname  
  
GO