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-35 System.Specauth
|
Column Name
|
Type
|
Length
|
Description |
|---|
|
USERID
|
CHAR
|
20
|
Authorized DBEUserID or
authorization group
|
|
DBA
|
CHAR
|
2
|
DBA authority: |
| | | | Y for yes |
| | | | N for no
|
|
RESOURCE | CHAR | 2 | Resource authority: |
| | | | Y for yes |
| | | | N for no
|
| CONNECT | CHAR | 2 | Connect Authority: |
| | | | Y for yes |
| | | | N for no
|
| MONITOR | CHAR | 2 | Connect Authority: |
| | | | Y for yes |
| | | | N for no
|
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@BROCK |Y |N |N |N
PURCHDBMAINT |N |Y |N |N
PURCH |N |N |Y |N
MICHELE@DING |Y |N |N |N
GEORGE@DBMS |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
|
