HP 3000 Manuals

ALLBASE/SQL Reference Manual

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

These two users will be able to start DBE sessions, retrieve data from
table PurchDB.Inventory, and update three columns in the table.

     ADD CLEM@THOMAS, GEORGE@CRAMMER TO GROUP Warehse

Clem no longer has any of the authorities associated with group Warehse.

     REMOVE CLEM@THOMAS 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 

MPE/iX 5.5 Documentation