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