Removes the specified user from the system.
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.
Dropped users cannot be recovered; they must be recreated.
If you want to disable a user, use ALTER USER and set DISABLED = TRUE instead.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Important
When you drop a user, the folders, worksheets, and dashboards owned by that user become inaccessible and do not transfer to another user unless sharing is enabled.
Share recipients with View, View + Run, and Edit permissions will retain their assigned permissions and can still access the shared folders, worksheets, and dashboards. However, only users with Edit permissions can modify or delete the shared folders, worksheets, and dashboards. If you don’t give Edit permissions to at least one other user before you drop the owner, that owner’s folders, worksheets, and dashboards cannot be deleted.
If a dropped user’s worksheets do not have sharing enabled, an administrator can recover up to 500 worksheets owned by the user.
Caution
Any worksheets in the Classic Console will be permanently deleted, and dashboards will be inaccessible if they were not previously shared with another user.
Examples¶RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4