在sqlserver中，给新添加的用户付所有表的操作权限
发布时间：2020-12-12 16:07:43 所属栏目：MsSql教程 来源：网络整理
导读：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 @ro
|
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 lycadmin' print @str ??????? exec(@str) ??????? set @roworder = @roworder + 1 end drop table #tmp go
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |