 |
» |
|
|
|
SYSTEM.MODAUTH contains RUN authorities for
application programs. This view, along with the
SYSTEM.COLAUTH, SYSTEM.PROCAUTH,
SYSTEM.SPECAUTH, and SYSTEM.TABAUTH views,
contains the authorities for the DBEnvironment. Table 8-18 System.Modauth | Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or authorization group | | NAME | CHAR | 20 | Name of the module for which the user has RUN authority | | OWNER | CHAR | 20 | Owner of the module for which the user has RUN authority |
EXAMPLE | |
SELECT * FROM System.Modauth;
--------------------+--------------------+--------------------
USERID |NAME |OWNER
--------------------+--------------------+--------------------
JIM |CEXP06 |JOHN
KAREN |CEXP06 |JOHN
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
