3. Statements : OpenROAD SQL Statements : Alter Group Statement : Examples—Alter Group Statement
 
Share this page                  
Examples—Alter Group Statement
The following examples add and drop user identifiers from the user list associated with a group identifier:
1. Add users to the group, sales_clerks.
alter group sales_clerks
    add users (dannyh, helent);
2. Drop three users from the group, tel_sales.
alter group tel_sales
    drop users (harryk, joanb, elainet);
3. In an application, drop all users from the group, researchers.
alter group researchers drop all;