Chapter 1: System Procedures

sp_dropuser

Drops a user from the current database.

sp_dropuser name_in_db

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.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect