ALTER GROUP Usage

No Nesting of Groups

You cannot add a group to another group. You can add only users to a group.

Adding Users to a Group

The following ALTER GROUP statement adds three users to the hr_corp group:

alter group hr_corp
  add user sam, flo, guy;

Dropping a User from a Group

In the following ALTER GROUP statement, user sue is dropped from the hr_corp group:

alter group hr_corp
  drop user sue;