ALLBASE/SQL Reference Manual > Chapter 10 SQL Statements A - D

DROP GROUP

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

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, George TO GROUP Warehse

Clem no longer has 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

DROP DBEFILESET

DROP INDEX