---******************更改權限以添加HHRC用戶*************************--step1 添加第三方用戶，如"chn"--step2 運行sql，加對象權限移至第三方用戶--step3 添加hhrc用戶--step4 運行sql，將對象權限移至hhrc用戶declare @tblname varchar(30)declare @tblown varchar(50)declare tbl_cur cursor forselect name from sysobjects where uid='5' and status>=0 and  xtype in ('U','P')--select * from sysusersopen tbl_curfetch next from tbl_cur into @tblnamewhile @@fetch_status=0beginset @tblown='web56433.'+@tblnameEXEC sp_changeobjectowner @tblown, 'chn'print @tblnamefetch next from tbl_cur into @tblnameendclose tbl_curdeallocate tbl_cur

--手動修改系統表--設備可以手動修改表exec sp_configure 'allow updates',1RECONFIGURE WITH OVERRIDE--更改對象所有者update sysobjects set uid = 1 where uid = 5update 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',0RECONFIGURE WITH OVERRIDE