Back to Questdb

DROP GROUP reference

documentation/query/sql/acl/drop-group.md

latest915 B
Original Source

import { EnterpriseNote } from "@site/src/components/EnterpriseNote"

<EnterpriseNote> RBAC provides fine-grained database permissions management. </EnterpriseNote>

DROP GROUP - remove an existing group.

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


Syntax

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

questdb-sql
DROP GROUP admins;

DROP GROUP IF EXISTS admins;

It can be verified with:

questdb-sql
SHOW GROUPS;

that does not include admins in its result.