One of our developers with blanket privilege on a database wanted to create a regular user mapped to a login when what he mistakenly created was a user without login and now I'm unable to remove the user. DROP USER XX command runs forever with no result nor an error. The user doesn't own any schemas as well. How can I remove this user?
Thank you

  • what you are getting the error? – Md Haidar Ali Khan Oct 18 '16 at 7:59
  • "command runs forever with no result nor an error" – Stackoverflowuser Oct 18 '16 at 8:01
  • Do you have "ALTER ANY USER permission on the database of that user". – Md Haidar Ali Khan Oct 18 '16 at 8:05
  • I hope this isn't a production db that a developer has 'blanket' permissions on. Hearing that anywhere makes me choke on my morning coffee. – Ian_H Oct 18 '16 at 8:32
  • I'm SA. It's UAT. – Stackoverflowuser Oct 18 '16 at 10:28

Check for any blocking SPIDs when you have issued the DROP USER XXX command.

Then kill.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.