文章 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,     我测试的时候...

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

产品推荐

云原生数据仓库AnalyticDB

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

+关注