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