Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.DBF_REF_SESSION_COUNT
Because Oracle does not allow grant select on views using v$xxx and we need to grant permission for SYSMNTR, our solution is to refresh a table with this data which we can grant. Note we make a special exception to our rule of not using REF views in other places and use this REF view in ADM_LOCKED_STATUS.
|
Column |
Comment |
|---|---|
|
NUM_SESSIONS_INCLUDING_SYS |
|
|
MAX_SESSIONS_ALLOWED |
|
|
NUM_USER_SESSIONS |
|
|
NUM_FPS_SESSIONS |
|
|
SESSION_LIST |
|
|
LOG_MODE |
|
|
ONE_ROW |
A column whose value is 1 which is the primary key of the table ensuring only one row. (* inherited from FPSINPUT.GEN_SITE) |