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 |
 |
REMOVE { DBEUserID GroupName ClassName } [,...] FROM GROUP [Owner.]TargetGroupName
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.
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.