文章 2022-02-17 来自:开发者社区

Cannot execute as the database principal because the principal "guest" does not exist, this type of principal cannot be impersonated, or you do not ha

原文:Cannot execute as the database principal because the principal "guest" does not exist, this type of principal cannot be impersonated, or you do not have permission. 今天遇到这样一个问题:一个系统的作业需要给系统Support人....

文章 2022-02-16 来自:开发者社区

Msg 15138 The database principal owns a schema in the database, and cannot be dropped.

删除用户报错:   Msg 15138, Level16, State 1, Line 1 The database principal owns a schemain the database, and cannot be dropped.   解决办法(SSMS):   1.找到用户拥有的Schema     2.在Schema中找到db_ow...

文章 2022-02-16 来自:开发者社区

Cannot execute as the database principal because the principal "guest" does not exist, this type of principal cannot be impersonated, or you do not ha

今天遇到这样一个问题:一个系统的作业需要给系统Support人员开放SQL Agent下作业的查看、执行权限。数据库版本为SQL Server 2014 SP2,给这个系统Support人员的NT账号授予msdb数据库下面权限后:     该系统Support人员反馈在双击查看该作业时报下面错误。于是我测试,验证了一下这个权限是否OK,     我测试的时候...

本页面内关键词为智能算法引擎基于机器学习所生成,如有任何问题,可在页面下方点击"联系我们"与我们沟通。

产品推荐

{"cardStyle":"productCardStyle","productCode":"aliyun","productCardInfo":{"productTitle":"自建 MongoDB 迁移到云数据库","productDescription":"针对自建 MongoDB 数据库在运维复杂、扩容困难等方面的问题,本方案基于阿里云数据库 MongoDB,依托其自动化运维能力,助力企业高效管理数据库。云数据库还支持多重备份机制和跨可用区容灾,全面保障数据安全与业务连续性。","productContentLink":"https://www.aliyun.com/solution/tech-solution/migrate-self-managed-mongodb-to-cloud","isDisplayProductIcon":true,"productButton1":{"productButtonText":"方案详情","productButtonLink":"https://www.aliyun.com/solution/tech-solution/migrate-self-managed-mongodb-to-cloud"},"productButton2":{"productButtonText":"方案部署","productButtonLink":"https://www.aliyun.com/solution/tech-solution-deploy/2925785"},"productButton3":{"productButtonText":"查看更多技术解决方案","productButtonLink":"https://www.aliyun.com/solution/tech-solution/"},"productPromotionInfoBlock":[{"productPromotionGroupingTitle":"解决方案推荐","productPromotionInfoFirstText":"自建数据库迁移到云数据库","productPromotionInfoFirstLink":"https://www.aliyun.com/solution/tech-solution/mysql-rds","productPromotionInfoSecondText":"RDS MySQL 迁移至 PolarDB MySQL 版","productPromotionInfoSecondLink":"https://www.aliyun.com/solution/tech-solution/rds-polardb"}],"isOfficialLogo":false},"activityCardInfo":{"activityTitle":"","activityDescription":"","cardContentBackgroundMode":"LightMode","activityContentBackgroundImageLink":"","activityCardBottomInfoSelect":"activityPromotionInfoBlock"}}

云原生数据仓库AnalyticDB

定期发送云原生数据仓库AnalyticDB产品重大发布和技术干货

+关注