SYSTEM.GROUP contains a row for each user or group that belongs to
an authorization group. Each user, whether an individual user or
another authorization group, has an entry for each authorization
group to which he or she is a member. This view is
initially empty, but is updated whenever ALLBASE/SQL processes
a CREATE GROUP, ADD TO GROUP,
TRANSFER OWNERSHIP (of a group), REMOVE
FROM GROUP, or DROP GROUP statement.
SYSTEM.GROUP can be used with SYSTEM.COLAUTH,
SYSTEM.MODAUTH, SYSTEM.SPECAUTH, and SYSTEM.TABAUTH
to determine authorities granted to authorization
groups.
You can use this table to determine all the members of a
particular authorization group or how many authorization
groups to which a particular user belongs. For example, if
you want to know all the users in the Receiving authorization
group, enter:
isql=> SELECT UserId FROM System.Group
> WHERE GroupID='RECEIVING';
|
Table 8-14 System.Group
Column Name
|
Type
|
Length
|
Description |
---|
USERID
|
CHAR
|
20
|
DBEUserID or authorization group that
is a member of the GROUPID
|
GROUPID
|
CHAR
|
20
|
Authorization group name
|
OWNER
|
CHAR
|
20
|
Owner of the
authorization group
|
NMEMBERS
|
INTEGER
|
4
|
Number of members in the
authorization group
|
Example |
 |
SELECT * FROM System.Group;
--------------------+--------------------+--------------------+-----------
USERID |GROUPID |OWNER |NMEMBERS
--------------------+--------------------+--------------------+-----------
PURCHMANAGERS |PURCHMANAGERS |JOHN@BROCK | 3
MARGY@RYAN |PURCHMANAGERS |JOHN@BROCK | 0
RON@HART |PURCHMANAGERS |JOHN@BROCK | 0
SHARON@MULDOON |PURCHMANAGERS |JOHN@BROCK | 0
PURCHDBMAINT |PURCHDBMAINT |JOHN@BROCK | 4
ANNIE@MELCHOIR |PURCHDBMAINT |JOHN@BROCK | 0
DOUG@DOLAN |PURCHDBMAINT |JOHN@BROCK | 0
DAVID@BLOOM |PURCHDBMAINT |JOHN@BROCK | 0
PURCHASING |PURCHASING |JOHN@BROCK | 5
AJ@SERED |PURCHASING |JOHN@BROCK | 0
JORGE@GUERRERO |PURCHASING |JOHN@BROCK | 0
RAGAA@QUILLEN |PURCHASING |JOHN@BROCK | 0
GREG@SAWYER |PURCHASING |JOHN@BROCK | 0
KAREN@RIZZO |PURCHASING |JOHN@BROCK | 0
RECEIVING |RECEIVING |JOHN@BROCK | 4
AL@DAL |RECEIVING |JOHN@BROCK | 0
---------------------------------------------------------------------------
First 16 rows have been selected
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|