ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 295
SQL Statements A - D
ADD TO GROUP
ADD TO GROUP
The ADD TO GROUP statement adds one or more users or groups, or a combination of users
and groups, to an authorization group.
Scope
ISQL or Application Program
SQL Syntax
ADD { DBEUserID
GroupName
ClassName }[,...]TO GROUP TargetGroupName
Parameters
DBEUserID identifies a user to be added. You cannot specify the name
of the DBECreator.
GroupName identifies a group to be added.
ClassName identifies a class to be added.
TargetGroupName is the name of the authorization group to which the
specified users, groups, and classes are to be added.
Description
• You can specify a single parameter chosen from the available types. You can also specify
multiple parameters (using the same or multiple types) separating them with commas.
• Two authorization groups cannot be members of each other, that is group membership
cannot follow a circular chain. If, for example, group3 is a member of group2, and
group2 is a member of group1, group1 cannot be a member of group2 or group3.
• You cannot add an authorization group to itself.
• When you specify several users or groups in one ADD TO GROUP statement,
ALLBASE/SQL ignores any invalid names, but processes the valid names.
Authorization
You can use this statement if you have OWNER authority for the authorization group or if
you have DBA authority.
Example
CREATE GROUP Warehse
GRANT CONNECT TO Warehse