DROP USER

Remove a user from the current database.

Syntax
      DROP USER username

Key
   username    Name of the user to be dropped.

A user that owns securables cannot be dropped.

Example

DROP USER JaneDoe;

"A chic type, a rough type, an odd type - but never a stereotype" - Jean-Michel Jarre

Related commands:

CREATE USER
ALTER USER

Equivalent Oracle command:

DROP USER