澳门新蒲京娱乐


Services不能够运营方法澳门新蒲京娱乐:

怎么创建存储过程澳门新蒲京娱乐:

server把数据库所有用户存储过程的EXEC权限赋另一角色

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

相关文章

No Comments, Be The First!
近期评论
    功能
    网站地图xml地图