ADD USER reference

To add user to one or more groups in the database, the ADD USER keywords are used.

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​

Flow chart showing the syntax of the ADD USER keyword

Description​

ADD USER adds a user to one or more groups.

Examples​

ADD USER john to management, audit;

It can be verified with:

SHOW GROUPS john;

that yields:

name
management
audit