Solved

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

  • 15 May 2024
  • 1 reply
  • 18 views

Badge

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.

icon

Best answer by juriaan.hensbroek 15 May 2024, 15:39

View original

1 reply

Badge

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.

 

Reply