SQL Server, cannot alter the user 'dbo', 如何解决SQL Server不能更改dbo问题
来源:互联网 发布:python 斜杠 替换 编辑:程序博客网 时间:2024/05/27 20:14
Some times we may get the below error while updating the login from dbo to some other login from user mapping window.
1. I have database which is mapped with dbo login and dbo schema.
2. I tried to update the database with app_user login, then it displays that error message.
To fix the issue we need to change the default owner to 'sa' and then tried to update the login.
Use database_name
sp_changedbowner 'sa'
It may cause because dbo is mapped with some other login, then we need to change the dbo login name to 'sa', it is because the sa login is reffered as dbo and it will exists in all the databases. So we should not modify the dbo login to any other login except 'sa'.
1. I have database which is mapped with dbo login and dbo schema.
2. I tried to update the database with app_user login, then it displays that error message.
To fix the issue we need to change the default owner to 'sa' and then tried to update the login.
Use database_name
sp_changedbowner 'sa'
It may cause because dbo is mapped with some other login, then we need to change the dbo login name to 'sa', it is because the sa login is reffered as dbo and it will exists in all the databases. So we should not modify the dbo login to any other login except 'sa'.
如果dbo map到非sa的login时,在更改dbo时,会遇到一些错误,解决办法是把数据库的默认owner更改为sa,然后在编辑dbo。
Use database_name
sp_changedbowner 'sa'
转自: http://calyansql.blogspot.com/2012/07/cannot-alter-user-dbo-microsoft-sql.html
0 0
- SQL Server, cannot alter the user 'dbo', 如何解决SQL Server不能更改dbo问题
- SQL Server dbo
- SQL Server之dbo
- MS SQL Server中dbo
- sql server 如何所有者转dbo的方法
- sql server错误21776:[SQL-DMO]名称"dbo"在Users集合中 不能更改 SA 密码在企业管理器
- SQL SERVER中[dbo]的解释
- MS SQL Server 2000 数据库使用备份还原造成dbo登录名丢失解决法
- MS SQL Server 2000 数据库使用备份还原造成dbo登录名丢失解决法(转)
- sql server登录名与数据库用户名dbo的差别
- [SQL Server]监控磁盘IO错误,msdb.dbo.suspect_pages
- Ms SQL Server中的系统表dbo.sysobject
- sql server登录名与数据库用户名dbo的差别
- sql server所有表的所有者恢复为dbo
- SQL Server 对象名 'master.dbo.spt_values'无效,错误208
- 数据库SQL Server 如何将数据库表名等前缀转换成dbo
- sql中的DBO
- sql server 2005 T-SQL ALTER USER (Transact-SQL)
- 理解 PHP 中的 Streams
- 高效JQuery代码编写
- Android Theme的设置
- 洗牌算法
- 原创诗集一
- SQL Server, cannot alter the user 'dbo', 如何解决SQL Server不能更改dbo问题
- linux下的目录解析
- java 发送http请求
- JqGrid中文文档之TreeGrid
- 奇数魔方矩阵的实现
- 十条有用的 GoLang技术
- 生产环境下实践DDD中的规约模式
- 使用SecureCRT的SFTP在WINDOWS与LINUX之间传输文件
- iOS界面设计切图小结