Failed to delete User in database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Failed to delete User in database

Hi 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,
Roman
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251369&SiteID=1 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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
Ravi K
]]>