SQL Language Guide : 8. SQL Statements : CREATE GROUP : CREATE GROUP Examples
 
Share this page                  
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);