---******************更改权限以添加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

--手动修改系统表            --设备可以手动修改表            exec sp_configure ''allow updates'',1            RECONFIGURE WITH OVERRIDE            --更改对象所有者            update sysobjects set uid = 1 where uid = 5            update sysobjects set uid = 5 where uid = 1 AND xtype != ''S''            update sysobjects set uid = 1  where name = ''syssegments''            update sysobjects set uid = 1  where name = ''sysconstraints''            exec sp_configure ''allow updates'',0            RECONFIGURE WITH OVERRIDE