Skip to main content
To homepage To homepage
Solved

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

  • May 15, 2024
  • 1 reply
  • 208 views
J
Contributor
Forum|alt.badge.img

I have a database role on my DSA which cannot be adjusted or removed. When I delete the role and deploy I get an error: “An error occurred during drop role. See exception details for the failing object: Drop failed for DatabaseRole 'SBIE'. The database principal owns a schema in the database, and cannot be dropped.”.

What does this mean and where should I look to solve this issue. In the end I want to have this database rule deleted. Perhaps I could do it outside TX, but I want to check the options in TX first.

Best answer by juriaan.hensbroek

Think I found it. Not sure if it's created within TX or not, but there are several schemas on the database which are not visible in TX. One of these is owned by the database role causing the errors.

I will check if we can delete this schema.

Consider it solved.

 

1 reply

J
Contributor
Forum|alt.badge.img

Think I found it. Not sure if it's created within TX or not, but there are several schemas on the database which are not visible in TX. One of these is owned by the database role causing the errors.

I will check if we can delete this schema.

Consider it solved.

 

Terms and ConditionsCookie settingsAccessibility statement