4. SQL Statements : ALTER GROUP : ALTER GROUP Examples
 
Share this page                  
ALTER GROUP Examples
Add and drop user identifiers from the user list associated with a group identifier:
1. Add users to the group, sales_clerks.
EXEC SQL ALTER GROUP sales_clerks
    ADD USERS (dannyh, helent);
2. Drop three users from the group, tel_sales.
EXEC SQL ALTER GROUP tel_sales
    DROP USERS (harryk, joanb, elainet);
3. In an application, drop all users from the group, researchers.
EXEC SQL ALTER GROUP researchers DROP ALL;