DROP USER reference - Questdb

import { EnterpriseNote } from "@site/src/components/EnterpriseNote"

<EnterpriseNote> RBAC provides fine-grained database permissions management. </EnterpriseNote>

DROP USER - drop an existing user

For full documentation of the Access Control List and Role-based Access Control, see the RBAC operations page.

Syntax

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.

questdb-sql

DROP USER john;

DROP USER IF EXISTS john;

It can be verified with:

questdb-sql

SHOW USERS;

that does not include john in its result.