DROP USER¶

Removes the specified user from the system.

See also:: CREATE USER , ALTER USER , SHOW USERS , DESCRIBE USER

Syntax¶

DROP USER [ IF EXISTS ] <name>

Copy

Parameters¶

name: Specifies the identifier for the user to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes¶

Dropped users cannot be recovered; they must be recreated.

If you wish to disable a user instead, use ALTER USER and set DISABLED = TRUE.

Examples¶

DROP USER user1;

Copy

Language: English