用游标 declare tb cursor local for select name from sysobjects where name like '__yyy___ ' declare @name sysname open tb fetch tb into @name while @@fetch_status = 0 begin EXEC(N 'GRANT SELECT ON ' + @name + ' TO [Assistant] ') -- 括号不匹配而已 fetch tb into @name end close tb deallocate tb
declare tb cursor local
for
select name from sysobjects where name like '__yyy___ '
declare @name sysname
open tb
fetch tb into @name
while @@fetch_status = 0
begin
EXEC(N 'GRANT SELECT ON ' + @name + ' TO [Assistant] ') -- 括号不匹配而已
fetch tb into @name
end
close tb
deallocate tb
缺点是:对应用程序的改动可能比较大,调试的时候比较麻烦。需要架设应用服务器。...
优点是:适用于多客户端的情况。可以减少数据库服务器的运行负荷。...不知道,这样行不行,如果可以的话,楼主可以试试看。