3. Statements : OpenROAD SQL Statements : Create Group Statement : Parameters—Create Group Statement
 
Share this page                  
Parameters—Create Group Statement
This statement has the following parameters:
group id
Is the group identifier. It must be a valid object name that is unique among all user, group, and role identifiers in the installation. If an invalid identifier is specified in the list of group identifiers, the DBMS Server returns an error but processes all valid group identifiers. Group identifier names are stored in the iiusergroup catalog in the iidbdb database.
user id
Must be a valid user name. If an invalid user identifier is specified, the DBMS Server issues an error but processes all valid user identifiers. A group can contain any number of users. A group identifier can be created without specifying a user list. To add users to an existing group identifier, use the alter group statement (see Alter Group Statement).