Drops a user from the current database.
is the user’s name in the current database’s sysusers table.
Drops the user “albert” from the current database. The user “albert” can no longer use the database:
sp_dropuser drops a user from the current database by deleting the user’s row from sysusers.
You cannot drop a user who owns objects in the database.
You cannot drop a user who has granted permissions to other users.
You cannot drop the Database Owner from a database.
If other users are aliased to the user being dropped, their aliases are also dropped. They no longer have access to the database.
You cannot drop a user from a database if the user owns a stored procedure that is bound to an execution class in that database. See sp_bindexeclass.
Only the Database Owner, a System Administrator, or a System Security Officer can execute sp_dropuser.
Commands grant, revoke, use
System procedures sp_addalias, sp_adduser, sp_bindexeclass, sp_droplogin