I have a user identified as a orphan user that I cannot drop. The user is not listed in the Logins folder or the Users folder for the database but when I query the database with select
= '\xyz' it returns a row. I get the following
error when I try to DROP USER [\xyz]; OR exec sp_revokedbaccess '[\xyz]'. Any ideas?
Msg 15151, Level 16, State 1, Line 2
Cannot drop the user '\xyz', because it does not exist or you do not have permission
View Complete Post