|
|
The ADD TO GROUP statement adds one or more users or groups, or a
combination of users and groups, to an authorization group.
ISQL or Application Program
ADD {DBEUserID
GroupName
ClassName}[,...] TO GROUP TargetGroupName
- 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.
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.
You can use this statement if you have OWNER authority for the authorization
group or if you have DBA authority.
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
|