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

最新推荐文章于 2021-04-22 15:51:00 发布
最新推荐文章于 2021-04-22 15:51:00 发布
阅读量3k 收藏 1
点赞数
分类专栏： SQL Server安全
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kevinsqlserver/article/details/8128795
版权
在尝试删除SQL Server数据库用户时遇到错误15138，该用户拥有数据库中的schema。解决方案包括更改schema的所有权至dbo或其他用户，然后删除目标用户。具体步骤包括查询用户拥有的schema，将db_owner的所有权转移，再次确认用户无schema，最后执行用户删除操作。
摘要由CSDN通过智能技术生成

删除用户报错：

 

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_owner将Schema Owner由test6改为dbo或者其他用户

 

 

3.删除用户test6

 

或者用下面的语句删除：

 

---查询用户test6拥有的

最低0.47元/天 解锁文章
KevinLiu
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
SQL Server中删除用户时报错，提示：The database principal owns a schema in the database, and cannot be dropped（转载...
02-20 414
Description of the problem: When you tried to drop a user, you got this message: Error: 15138 The database principal owns a schema in the database, and cannot be dropped. Cause: That mea...
The database principal owns a schema in the database, and cannot be dropped. (.Net SqlClient Data Pr
weixin_30955341的博客
08-03 107
解决microsoft sql server error:15138的方法 http://blog.csdn.net/gray13/article/details/4458523 用sp_change_users_login消除Sql Server的孤立用户 http://www.cnblogs.com/13590/archive/2007/09/28/909643.htm...
The database principal owns a schema in the database, and cannot be dropped
kaqi
08-06 291
    http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/     SELECT s.name FROM sys.schemas s WHERE ...
解决“the database principal owns a schema in the database and cannot be dropped“问题
qq_37233070的博客
08-04 1566
解决"the database principal owns a schema in the database and cannot be dropped"问题； 这个提示就是说明要删除的用户名下存在架构，可以执行以下两步来解决这一问题： **首先**查询该用户名下的架构： SELECT s.name FROM sys.schemas s WHERE s.principal_id= USER_ID('entradeRead2'); entradeRead2就是要删除的用户名 **然后**执行
How to solve the question "Drop failed for User 'SQL2K5User'. "
weixin_30896825的博客
08-13 117
TITLE: Microsoft SQL Server Management Studio------------------------------ Drop failed for User 'SQL2K5User'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Mic...
pca.zip_FERET DATABASE _FERET.MAT_On the Up_PCA.m_feret
09-24
This package implements basic Principal Component Analysis in Matlab and tests is with grayscale portion of the FERET database. Images are not preprocessed and it is up to the user to preprocess the ...
The principal game: A group consequence procedure to increase classroom in-task behavior
06-29
The principal game: A group consequence procedure to increase classroom in-task behavior THE PRINCIPAL GAME: A GROUP CONSEQUENCE PROCEDURE TO INCREASE CLASSROOM ON-TASK BEHAVIOR’ CRAIG B. DARCH ...
pca.zip_The Image_bounding box_bounding box and pca_pca image_sh
09-24
在"pca.zip_The Image_bounding box_bounding box and pca_pca image_sh"这个压缩包中，我们可以看到一个名为“pca.m”的文件，这很可能是用MATLAB编写的一个函数，用于计算图像中形状的定向边界框（oriented ...
createDistMat.rar_FERET DATABASE _createDistMat_feret _人脸识别
07-13
PCA人脸识别 This package implements basic Principal Component Analysis in Matlab and tests is with grayscale portion of the FERET database. Images are not preprocessed and it is up to the user to ...
PCA.rar_The Image
09-20
PCA（主成分分析，Principal Component Analysis）是一种统计方法，常用于数据降维，尤其是在处理高维数据时。在图像处理领域，PCA也被广泛应用于图像压缩、特征提取和人脸识别等任务。"PCA.rar_The Image"这个标题...
the database principal owns a service in the database -- can't drop a user
编程岁月
05-08 559
There are two options here.     1. You map orphan user to login if user is required. sp_change_users_login   2. Run below code and check which service user owns.   select s.name as ServiceNa
SQL Server Error: The database principal owns a service in the database, and cannot be dropped
编程岁月
08-02 411
There are two options here. 1. You map orphan user to login if user is required. sp_change_users_login 2. Run below code and check which service user owns. select s.name as ServiceName from sys...
解决microsoft sql server error:15138的方法
热门推荐
gray13的专栏
08-18 1万+
When you drop a user in Microsoft SQL Server, an error occurs: 1. Drop failed for User fastnet（就是要删除的user名）.  (Microsoft.SqlServer.Smo)2. An exception occurred while executing a Transact-SQL sta
SQL server-Drop user issues
aoyi6589的博客
06-14 109
1.The database principal owns a schema in the database, and cannot be dropped 2.User:sa trying to delete a user 'test' which exists in the db 'TestDB' 3.Run the below query to check the resul...
解决删除用户时报错的问题：Msg 15138, Level16, State 1, Line 1 The database principal owns a schemain the database...
weixin_30706691的博客
08-01 726
USE mydata; SELECT s.name FROM sys.schemas s WHERE s.principal_id= USER_ID('developer'); --将db_owner Schema的Owner改为dbo ALTER AUTHORIZATION on SCHEMA::db_owner TO dbo; ---再次查询用户test6拥有...
Login 'XXX' owns one or more database(s). Change the owner of the database(s) before dropping the lo...
网络资源
04-22 271
Login 'XXX' owns one or more database(s). Change the owner of the database(s) before dropping the login. 1.Use below commands to check which database has owned by login 'XXX' select name [database]...
The database principal owns a schema in the database, and cannot be dropped.
最新发布
06-07
这个错误是因为您正在尝试删除拥有模式（schema）的数据库主体（database principal）。在 SQL Server 中，模式是一种逻辑容器，可以用来组织和管理数据库对象，如表、视图、存储过程等。每个数据库主体都可以拥有一个或多个模式。如果您尝试删除一个拥有模式的数据库主体，将会收到如上所述的错误消息。 要解决这个问题，您需要按照以下步骤操作： 1. 首先，使用以下语句查找拥有模式的数据库主体的名称和模式的名称： ``` USE [database_name]; SELECT s.name AS schema_name, dp.name AS principal_name FROM sys.schemas s INNER JOIN sys.database_principals dp ON dp.principal_id = s.principal_id WHERE dp.name = 'principal_name'; ``` 请将 "database_name" 替换为您的数据库名称，将 "principal_name" 替换为您要删除的数据库主体名称。 2. 然后，将该数据库主体从其模式中移除。例如，以下语句将名为 "principal_name" 的数据库主体从名为 "schema_name" 的模式中移除： ``` USE [database_name]; ALTER AUTHORIZATION ON SCHEMA::[schema_name] TO dbo; ``` 请将 "database_name" 替换为您的数据库名称，将 "schema_name" 替换为上一步中找到的模式名称。 3. 最后，您可以使用 DROP USER 或 DROP LOGIN 语句删除该数据库主体。例如，以下语句将名为 "principal_name" 的数据库主体删除： ``` USE [database_name]; DROP USER [principal_name]; ``` 请将 "database_name" 替换为您的数据库名称，将 "principal_name" 替换为要删除的数据库主体名称。 请注意，在执行任何删除操作之前，请务必备份您的数据库以防止数据丢失。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值