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;
Last modified date: 08/29/2024