DROP GROUP reference

Enterprise—

RBAC provides fine-grained database permissions management.

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

DROP GROUP [IF EXISTS] groupName;

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.

DROP GROUP admins;

DROP GROUP IF EXISTS admins;

It can be verified with:

SHOW GROUPS;

that does not include admins in its result.