22,206
社区成员
发帖
与我相关
我的任务
分享
declare @roworder int
declare @name varchar(50)
declare @str varchar(500)
declare @cnt int
select identity(int,1,1) roworder ,name into #tmp from sysobjects where xtype = 'u' --name like 'PLMST_%'
select @cnt = count(*) from #tmp
set @roworder = 1
while @roworder < = @cnt
begin
select @name = name from #tmp where roworder = @roworder
--print @name
set @str = 'grant all on '+@name+ ' to 用户名'
--print @str
exec(@str)
set @roworder = @roworder + 1
end