DBA_XS_APPLIED_POLICIES
The DBA_XS_APPLIED_POLICIES data dictionary view displays all database objects on which Real Application Security data security policies are enabled.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
SCHEMA |
VARCHAR2(128) |
NOT NULL |
Schema containing the object |
OBJECT |
VARCHAR2(128) |
NOT NULL |
Name of the data security enabled object in the database |
POLICY |
VARCHAR2(128) |
Name of the data security policy associated with the object | |
POLICY_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the data security policy associated with the object |
SEL |
VARCHAR2(3) |
Policy enabled for SELECT statements |
|
INS |
VARCHAR2(3) |
Policy enabled for INSERT statements |
|
UPD |
VARCHAR2(3) |
Policy enabled for UPDATE statements |
|
DEL |
VARCHAR2(3) |
Policy enabled for DELETE statements |
|
IDX |
VARCHAR2(3) |
Policy enabled for INDEX statements |
|
STATUS |
VARCHAR2(8) |
ENABLED if the data security policy is enabled for the object, else DISABLED |
|
ROW_ACL |
VARCHAR2(3) |
Object has the row ACL column | |
OWNER_BYPASS |
VARCHAR2(3) |
Policy bypassed by object owner |