SQL Server Performance Forum – Threads Archive
Failed to delete User in databaseHi All, I have problem with user deletion in database.
First I created Login My_User with SQL Server authentification with blank password and default database My_Database. Then I added User to My_Database using login My_User and user name My_User. I marked checkbox "dbowner"
After that I needed to delete login and user. I deleted login succesfully. Then tried to delete My_User from database. Got exception about owing schema. Then for dbowner schema I changed schema owner from My_User to dbo. Deleted again and got another exception
‘The database principal owns a database role and cannot be dropped’. Can not find what else I have to do to delete My_User from database. I would greatly appreciate any help,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251369&SiteID=1 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.
As per me some schema is owned by My_User. Please check the security detail carefully. Just ensure that you transfer all the schema own by My_user to some other user before deleting MY_user. Thanks and Regards