HPlogo ALLBASE/SQL Reference Manual > Chapter 11 SQL Statements E - R

REMOVE FROM GROUP

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

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.



REMOVE DBEFILE

RENAME COLUMN