一般開發,sql server的數據庫所有者為dbo.但是為了安全,有時候可能把它換成其它的名稱.

所有者變換不是很方便.這里列出兩種供參考

一:

---******************更改權限以添加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.'[email protected]
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'