Skip to main content
To homepage To homepage

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.

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


Terms and ConditionsCookie settings