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
 
   GRANT SELECT,
         UPDATE (BinNumber,QtyOnHand,LastCountDate)
      ON PurchDB.Inventory
      TO Warehse

These two users will be able to start DBE sessions on PartsDBE, retrieve data from table PurchDB.Inventory, and update three columns in the table.

ADD Clem, George TO GROUP Warehse

Clem will no longer have any of the authorities associated with group Warehse.

REMOVE Clem FROM GROUP Warehse

Because this group does not own any database objects, it can be deleted. George no longer has any of the authorities once associated with the group.

DROP GROUP Warehse