DROP USER reference
DROP USER
- drop an existing user
For full documentation of the Access Control List and Role-based Access Control, see the RBAC operations page.
note
Role-based Access Control (RBAC) operations are only available in QuestDB Enterprise.
Syntax
Description
DROP USER
removes an existing user.
All related secrets are also deleted.
Unless the IF EXISTS
clause is applied, an error is raised and the command
fails if the user does not exist.
Examples
DROP USER john;
DROP USER IF EXISTS john;
It can be verified with:
SHOW USERS;
that does not include john
in its result.