DROP USER¶
Removes the specified user from the system.
- See also:
Syntax¶
DROP USER [ IF EXISTS ] <name>
Parameters¶
nameSpecifies 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 = TRUEinstead.
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:
After dropping the user, recover up to 500 worksheets owned by the user.
Before dropping the user, the user can share the worksheets or a folder of worksheets with another user and grant them edit permissions, or copy the contents of the worksheets to worksheets owned by another user.
Examples¶
DROP USER user1;