CREATE GROUP Statement

SQL Statements

CREATE ROLE Statement

DROP GROUP Statement

statement_DROP_GROUP ::= DROP [ IF EXISTS ] GROUP group_name

Description

The DROP GROUP statement deletes a group with the specified name. Users assigned to this group are not deleted when calling the DROP GROUP statement.

If the group of the specified name does not exist on the database, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

Only the security or configuration administrator may delete a group.

Example:

Deletes the XUSER user and the XGROUP group.

DROP USER xuser;
DROP GROUP xgroup;

See

• CREATE USER
• DROP USER
• CREATE GROUP
• Privileges and privilege subjects in SQL

CREATE GROUP Statement

SQL Statements

CREATE ROLE Statement