---******************更改权限以添加HHRC用户*************************
--step1 添加第三方用户,如"chn"
--step2 运行sql,加对象权限移至第三方用户
--step3 添加hhrc用户
--step4 运行sql,将对象权限移至hhrc用户
declare @tblname varchar(30)
declare @tblown varchar(50)
declare tbl_cur cursor for
select name from sysobjects where uid='5' and status>=0 and xtype in ('U','P')
--select * from sysusers
open tbl_cur
fetch next from tbl_cur into @tblname
while @@fetch_status=0
begin
set @tblown='web56433.'+@tblname
EXEC sp_changeobjectowner @tblown, 'chn'
print @tblname
fetch next from tbl_cur into @tblname
end
close tbl_cur
deallocate tbl_cur |