DROP GROUP reference

DROP GROUP - remove an existing 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 DROP GROUP keyword

Description

DROP GROUP removes an existing group.

Unless the IF EXISTS clause is applied, an error is raised and the command fails if the group does not exist.

When a group is removed, all members of the group lose the permissions inherited through the group.

Examples

DROP GROUP admins;

DROP GROUP IF EXISTS admins;

It can be verified with:

SHOW GROUPS;

that does not include admins in its result.