CREATE GROUP reference

CREATE GROUP - create a new group

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 CREATE GROUP keyword

Description

CREATE GROUP adds a new user group with no permissions.

The chosen name must be unique across all users (including the built-in admin), groups and service accounts. If the name has already been reserved, the command fails and an error is raised, unless the IF NOT EXISTS clause is included in the statement.

Contrary to users and service accounts, it is not possible to log in as group. A group only serves as a container for permissions which are shared between users.

Examples

CREATE GROUP admins;

CREATE GROUP IF NOT EXISTS admins;

It can be verified with:

SHOW GROUPS;

that yields:

name
admins