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 want to disable a user, use ALTER USER and set DISABLED = TRUE instead.

Caution

When you drop a user, the worksheets and dashboards owned by that user are also removed.

To retain access to the worksheets owned by a user, you have two options:

Examples

DROP USER user1;
Copy