![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/f10863d1-941a-46ea-b836-30a5d19f58b3.png)
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
View original