ALL_XDS_ACL_REFRESH
The ALL_XDS_ACL_REFRESH data dictionary view displays all static ACL refresh settings for tables that are accessible to the application user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
SCHEMA_NAME |
VARCHAR2(128) |
NOT NULL |
Name of schema |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of table |
ACL_MVIEW_NAME |
VARCHAR2(128) |
NOT NULL |
Name of ACL MV for this table |
REFRESH_MODE |
VARCHAR2(9) |
ON COMMIT, SCHEDULED, or ON DEMAND |
|
REFRESH_ABILITY |
VARCHAR2(11) |
COMPLETE or INCREMENTAL |
|
ACL_STATUS |
VARCHAR2(5) |
STALE or FRESH |
|
USER_SUPPLIED_MV |
VARCHAR2(1) |
Y or N |
|
START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
The refreshment job scheduled to run after the timestamp, if scheduled | |
REPEAT_INTERVAL |
VARCHAR2(4000) |
The repeat_interval to run the refreshment job, if scheduled |
|
REFRESH_COUNT |
NUMBER |
Number of times this ACL MV has been refreshed so far | |
COMMENTS |
VARCHAR2(240) |
Comments for the refreshment |