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
Sql-server – Unable to drop database user without login
loginssql serversql-server-2008-r2users
Related Question
- Sql-server – How to give an existing server login access to an attached/migrated database
- SQL Server 2012 Security – SQL Login Keeps Losing Access to Databases
- Sql-server – Can’t use msdb.dbo.sp_send_dbmail when in service broker – executes as guest
- Sql-server – Cannot systemctl start/stop mssql. mssql-server stuck in script upgrade mode. Cannot login either
- Sql-server – User connections without a login
- SQL Server – Resolving ‘Login Failed for User NT AUTHORITY\ANONYMOUS LOGON’ on Linked Server
- SQL Server – Why and How to Use User Without Login
Best Answer
Check for any blocking
SPID
s when you have issued theDROP USER XXX
command.Then kill.