DROP USER — remove a database role
DROP USER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP USER is simply an alternate spelling of
DROP ROLE.
CASCADE
Used to DROP USER statement compatible with Oracle.
Automatically drop objects (tables, functions, etc.) that are
contained in the user,
and in turn all objects that depend on those objects
(see Section 6.14). It must be used in Oracle database.
RESTRICT
Used to DROP USER statement compatible with Oracle.
Refuse to drop the user if it contains any objects. This is
the default. It must be used in Oracle database.
The DROP USER statement is a
LightDB extension. The SQL standard
leaves the definition of users to the implementation.