Was this helpful?
CREATE GROUP Examples
1. Create a group identifier for the telephone sales force of a company and put the user IDs of the salespeople in the user list of the group.
CREATE GROUP tel_sales WITH USERS = (harryk, joanb, jerryw, arlenep);
2. In an application, create a group identifier for the inventory clerks of a store and place their user IDs in the user list of the group.
EXEC SQL CREATE GROUP inv_clerk WITH USERS = (jeanies, louisem, joep);
Last modified date: 01/30/2023