 |
» |
|
|
|
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-19 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@FRANCIS |CEXP06 |JOHN@BROCK
KAREN@RIZZO |CEXP06 |JOHN@BROCK
---------------------------------------------------------------------------
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
|
|
