SYSTEM.SPECAUTH lists all users and authorization
groups and the special authorities they have been
granted. Because a user must be granted the special
authority CONNECT before being able to access the DBEnvironment,
every user or group that has CONNECT authority to the DBEnvironment
is listed.
ALLBASE/SQL updates
SYSTEM.SPECAUTH when processing a GRANT or REVOKE statement
specifying a special authority,
or when dropping a group with special authority.
SYSTEM.SPECAUTH, along with SYSTEM.COLAUTH, SYSTEM.INSTALLAUTH, SYSTEM.MODAUTH, SYSTEM.PROCAUTH,
SYSTEM.SPACEAUTH, SYSTEM.SPACEDEFAULT, and SYSTEM.TABAUTH,
contains the security scheme for the DBEnvironment.
CATALOG.SPECAUTH is identical in format to SYSTEM.SPECAUTH; it permits users without DBA authority or SELECT authority on SYSTEM.SPECAUTH to examine rows to which they have access.
Table 8-34 System.Specauth
| Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or authorization group |
| DBA | CHAR | 2 | |
| RESOURCE | CHAR | 2 | |
| CONNECT | CHAR | 2 | |
| MONITOR | CHAR | 2 | |
EXAMPLE |
 |
SELECT * FROM System.Specauth;
--------------------+---+--------+-------+-------
USERID |DBA|RESOURCE|CONNECT|MONITOR
--------------------+---+--------+-------+-------
HPRDBSS |N |N |N |N
TEMP |N |N |N |N
PUBLIC |N |N |N |N
SYSTEM |N |N |N |N
JOHN |Y |N |N |N
PURCHDBMAINT |N |Y |N |N
PURCH |N |N |Y |N
MICHELE |Y |N |N |N
GEORGE |N |N |Y |Y
--------------------------------------------------------------------------
Number of rows selected is 8
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
