CREATE GROUP reference

Enterprise—

RBAC provides fine-grained database permissions management.

Learn more

CREATE GROUP - create a new group

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

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