 |
» |
|
|
|
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@THOMAS, GEORGE@CRAMMER TO GROUP Warehse
|
Clem will no longer have any of the authorities associated with group Warehse.
REMOVE CLEM@THOMAS 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. |
