DROP GROUP

Use the DROP GROUP command to delete a group. This command does not delete the user accounts of the members of the group.

Syntax

Syntax for dropping a group:
DROP GROUP <name>

Input

The DROP GROUP command takes the following input:
Table 1. DROP GROUP input
Input Description
<name> The name of the group to be dropped.

Output

The DROP GROUP command has the following output:
Table 2. DROP GROUP output
Output Description
DROP GROUP The group was successfully deleted.

Privileges

You must be the admin user, the group owner, or your account must have the Drop privilege for thespecified group or for the Group object class

Usage

The following provides sample usage.
  • Drop the group staff: 
    MYDB.SCH1(USER)=> DROP GROUP staff;