CREATE GROUP reference

CREATE GROUP - create a new group

Syntax#

Flow chart showing the syntax of the CREATE GROUP keyword

Description#

CREATE GROUP adds a new user group with no permissions to QuestDB instance. Chosen name has to be unique across all users, groups and service accounts. Contrary to users and service accounts, it's not possible to log in as group. Group only serves as container for permissions, shared between users.

Examples#

CREATE GROUP admins;

It can be verified with:

SHOW GROUPS;

that yields:

name
admins