REMOVE FROM GROUP

The REMOVE FROM GROUP statement removes one or more users or authorization groups from membership in a specified authorization group.

Scope

ISQL or Application Programs

SQL Syntax

  REMOVE {DBEuserID 
          GroupName 
          ClassName}[,...]FROM GROUP [Owner.]TargetGroupName

Parameters

DBEUserID: identifies a user to be removed from the specified authorization group. If you specify several names, any invalid names are ignored but valid names are removed.
GroupName: identifies a group to be removed from the specified authorization group. If you specify several names, any invalid names are ignored but valid names are removed.
ClassName: identifies a class to be removed from the specified authorization group. If you specify several names, any invalid names are ignored but valid names are removed.
TargetGroupName: is the name of the authorization group from which the specified users and groups are to be removed.

Description

You cannot remove a member from a group if that member (or members of that member) used a DBA or REFERENCES privilege to which that member had access through that group to validate the creation of a currently existing foreign key in a table he or she owns.

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

These two users now are able to start DBE sessions on PartsDBE and PurchDB.Inventory, and to update three columns in the table.

REMOVE Clem FROM GROUP Warehse

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

DROP 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.