一般开发,SQL Server的数据库所有者为dbo。但是,为了安全,有时候可能把它换成其它的名称。所有者变换不是很方便,这里列出两种供参考。
方案一:更改权限以添加HHRC用户
1、添加第三方用户,如“chn”;
2、运行sql,加对象权限移至第三方用户;
3、添加hhrc用户;
4、运行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 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
方案二:
1、手动修改系统表;
2、设备可以手动修改表;
exec sp_configure 'allow updates',1RECONFIGURE WITH OVERRIDE
3、更改对象所有者。
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
本文作者: