HP 3000 Manuals HP 3000 Manuals
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
{DBEUserID}
ADD {GroupName} [,...] TO GROUP TargetGroupName
{ClassName}
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.
DROP GROUP Warehse