--用游标 declare @uname varchar(200) declare cur1 cursor for select name sysobjects where xtype='U' and status>0 open cur1 fetch next from cur1 into @uname while @@fetch_status=0 begin --写入你要处理的语句 exec ('GRANT SELECT ON '+ @uname +' TO username') fetch next from cur1 into @uname end close cur1 deallocate cur1
declare @uname varchar(200)
declare cur1 cursor for select name sysobjects where xtype='U' and status>0
open cur1
fetch next from cur1 into @uname
while @@fetch_status=0
begin
--写入你要处理的语句
exec ('GRANT SELECT ON '+ @uname +' TO username')
fetch next from cur1 into @uname
end
close cur1
deallocate cur1