Drops a user from the current database.
sp_dropuser name_in_db
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 albert
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.
System procedures sp_addalias, sp_adduser, sp_bindexeclass, sp_droplogin
