The Database Principal Owns A Schema In The Database, And Cannot Be Dropped


Error: "The Database Principal Owns A Schema In The Database, And Cannot Be Dropped"

This is very common error while we drop any sql user. This comes because particular user owns schema in database.

To fix same , Perform below steps:

1. Find schema owned by user

SELECT name FROM  sys.schemas WHERE principal_id = USER_ID('myUser')

2. Then, use the names found from the above query below in place of the SchemaName below

ALTER AUTHORIZATION ON SCHEMA::SchemaName TO dbo 


3. Drop your user.
 
DROP USER myUser



No comments:

Post a Comment