DROP USER removes a name from the list of authorized database users.
Syntax
DROP USER name [, ...]
Semantics
name
specifies the name of the user to drop.
Examples
DROP USER Fred