SYSTEM.INSTALLAUTH lists all users and authorization groups that have been granted INSTALL authority. ALLBASE/SQL updates SYSTEM.INSTALLAUTH when processing a GRANT INSTALL or REVOKE INSTALL statement, or when dropping a group having INSTALL authority.
SYSTEM.INSTALLAUTH, SYSTEM.COLAUTH, SYSTEM.MODAUTH, SYSTEM.PROCAUTH, SYSTEM.SPACEAUTH, SYSTEM.SPACEDEFAULT, SYSTEM.SPECAUTH, and SYSTEM.TABAUTH, contain the security scheme for the DBEnvironment.
CATALOG.INSTALLAUTH is identical in format to SYSTEM.INSTALLAUTH; it permits users without DBA authority or SELECT authority on SYSTEM.INSTALLAUTH to examine rows to which they have access.
Table 8-18 System.Installauth
|
Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or authorization group
|
| OWNER | CHAR | 20 | An owner name the USERID is authorized to use.
If blank, the USERID is authorized to use any owner name.
|
Example |
 |
SELECT * FROM System.Installauth;
--------------------+--------------------
USERID |OWNER
--------------------+--------------------
GEORGE@DBMS |
CLEM@DBMS |JOHN@BROCK
CLEM@DBMS |SUSAN@SMITH
---------------------------------------------------------------------------
Number of rows selected is 3
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
