ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 397
SQL Statements A - D
DROP GROUP
DROP GROUP
The DROP GROUP statement removes the definition of an authorization group from the
system catalog.
Scope
ISQL or Application Programs
SQL Syntax
DROP GROUP GroupName
Parameters
GroupName identifies the authorization group to be dropped.
Description
• You cannot drop an authorization group if it owns any tables, views, modules, or
authorization groups.
• You cannot drop a group if it has access to a DBA or REFERENCES privilege which was
used to validate the creation of a currently existing foreign key in a table owned by the
group or one of its members.
• You can drop a group even if it still has members.
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