ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 483
SQL Statements E - R
REMOVE FROM GROUP
Example
CREATE GROUP Warehse
GRANT CONNECT TO Warehse
GRANT SELECT,
UPDATE (BinNumber,QtyOnHand,LastCountDate)
ON PurchDB.Inventory
TO Warehse
ADD Clem, George 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 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.