ALLBASE/SQL Reference Manual (36216-90216)

482 Chapter11
SQL Statements E - R
REMOVE FROM GROUP
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.