mssql server把所有用户存储过程的exec权限赋另一角色
$sql=create procedure sp_grantproce(@username varchar(40))
as
begin
declare @user varchar(20),@name varchar(40)
declare t_cursor cursor for
select user_name(uid) as users,name from sysobjects where (xtype= 'p ' or xtype= 'x ') and status> 0
open t_cursor
fetch next from t_cursor into @user,@name
while @@fetch_status=0
begin
exec( 'grant execute on + '. + ' to )
fetch next from t_cursor into @user,@name
end
close t_cursor
deallocate t_cursor
end
go;