V$VPD_POLICY displays all the fine-grained security policies and predicates associated with the cursors currently in the library cache.
| Column | Datatype | Description |
|---|---|---|
ADDRESS |
RAW(4 | 8) |
Cursor address |
PARADDR |
RAW(4 | 8) |
Parent cursor address |
SQL_HASH |
NUMBER |
SQL hash number |
SQL_ID |
VARCHAR2(13) |
SQL identifier |
CHILD_NUMBER |
NUMBER |
Cursor's child number under the parent |
OBJECT_OWNER |
VARCHAR2(30) |
Owner of the object with the policy |
OBJECT_NAME |
VARCHAR2(30) |
Name of the object with the policy |
POLICY_GROUP |
VARCHAR2(30) |
Name of the policy group |
POLICY |
VARCHAR2(30) |
Name of the policy |
POLICY_FUNCTION_OWNER |
VARCHAR2(30) |
Owner of the policy function |
PREDICATE |
VARCHAR2(4000) |
Predicate for the policy (truncated to 4000 bytes in length) |