ALLBASE/SQL Reference Manual (36216-90216)

296 Chapter10
SQL Statements A - D
ADD TO GROUP
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, George TO GROUP Warehse
Clem will no longer have any of the authorities associated with group Warehse.
REMOVE Clem 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