server把数据库所有用户存储过程的EXEC权限赋另一角色lom599乐百家手机:

 百家乐-数据     |      2020-04-22 21:55

$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 '+@user+ '. '+@name+ ' to '+@username) fetch next from t_cursor into @user,@name end close t_cursor deallocate t_cursor end go;

mssql server把数据库教程全体顾客存款和储蓄进度的EXEC权限赋另一角色

上一篇:Services无法启动方法 下一篇:没有了