SQL Server Performance Forum – Threads Archive
unable to drop user in a Database
I am unable to drop a user in a Database.The name of the user is ‘HPOV’
When I try to delete it, I am getting an error message like "Drop failed for user ‘HPOV’
The DB principal owns a schema in the Database and cannot be dropped" Please help me to resolve this issue
Look at this: http://theshiva.us/technicalblog/ar…ma-in-the-database-and-cannot-be-dropped.aspx Satya
You need to change the owner back to db_datareader before you can drop the role:
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [db_datareader]
Then attempt to drop this role. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>