HP 3000 Manuals HP 3000 Manuals
REMOVE FROM GROUP
The REMOVE FROM GROUP statement removes one or more users or
authorization groups from membership in a specified authorization group.
Scope
ISQL or Application Programs
SQL Syntax
{DBEUserID}
REMOVE {GroupName} [,...] FROM GROUP [Owner.]TargetGroupName
{ClassName}
Parameters
DBEUserID identifies a user to be removed from the
specified authorization group. If you specify
several names, any invalid names are ignored but
valid names are removed.
GroupName identifies a group to be removed from the
specified authorization group. If you specify
several names, any invalid names are ignored but
valid names are removed.
ClassName identifies a class to be removed from the
specified authorization group. If you specify
several names, any invalid names are ignored but
valid names are removed.
TargetGroupName is the name of the authorization group from which
the specified users and groups are to be removed.
Description
You cannot remove a member from a group if that member (or members of
that member) used a DBA or REFERENCES privilege to which that member had
access through that group to validate the creation of a currently
existing foreign key in a table he or she owns.
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
ADD CLEM@THOMAS, GEORGE@CRAMMER TO GROUP Warehse
These two users now are able to start DBE sessions on PartsDBE and
PurchDB.Inventory, and to update three columns in the table.
REMOVE CLEM@THOMAS FROM GROUP Warehse
Clem no longer has any of the authorities associated with group Warehse.
DROP 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.
[REV BEG]