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
StackoverflowuserStackoverflowuser
asked Oct 18, 2016 at 7:44
-
what you are getting the error?Md Haidar Ali Khan– Md Haidar Ali Khan2016年10月18日 07:59:50 +00:00Commented Oct 18, 2016 at 7:59
-
"command runs forever with no result nor an error"Stackoverflowuser– Stackoverflowuser2016年10月18日 08:01:56 +00:00Commented Oct 18, 2016 at 8:01
-
Do you have "ALTER ANY USER permission on the database of that user".Md Haidar Ali Khan– Md Haidar Ali Khan2016年10月18日 08:05:42 +00:00Commented Oct 18, 2016 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– Ian_H2016年10月18日 08:32:15 +00:00Commented Oct 18, 2016 at 8:32
-
I'm SA. It's UAT.Stackoverflowuser– Stackoverflowuser2016年10月18日 10:28:27 +00:00Commented Oct 18, 2016 at 10:28
1 Answer 1
Check for any blocking SPIDs when you have issued the DROP USER XXX command.
Then kill.
PhilTM
32k10 gold badges86 silver badges108 bronze badges
Explore related questions
See similar questions with these tags.
lang-sql