Note
This view is available starting with V4.1.0.
Purpose
This view displays information about all columns associated with policies in the current tenant's tables or views. When a column is associated with a column-level policy, the corresponding policy is enforced during access to that column.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| OBJECT_OWNER | VARCHAR2(128) | YES | The owner of the object subject to the policy. |
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the object subject to the policy. |
| POLICY_GROUP | VARCHAR2(128) | NO | The name of the policy group. |
| POLICY_NAME | VARCHAR2(128) | NO | The name of the policy. |
| SEC_REL_COLUMN | VARCHAR2(128) | YES | The name of the column associated with the column-level policy. |
| COLUMN_OPTION | VARCHAR2(8) | NO | The policy option:
|
| COMMON | VARCHAR2(3) | NO | Reserved for compatibility. The value is fixed to NO. |
| INHERITED | VARCHAR2(3) | NO | Reserved for compatibility. The value is fixed to NO. |
Sample query
Query information about all columns associated with policies in the current tenant's tables or views.
obclient [SYS]> SELECT * FROM SYS.DBA_SEC_RELEVANT_COLS;
The query result is as follows:
+--------------+----------------+--------------+----------------+----------------+---------------+--------+-----------+
| OBJECT_OWNER | OBJECT_NAME | POLICY_GROUP | POLICY_NAME | SEC_REL_COLUMN | COLUMN_OPTION | COMMON | INHERITED |
+--------------+----------------+--------------+----------------+----------------+---------------+--------+-----------+
| SYS | V_SALES_SECURE | GROUP_SALES | POLICY_REGION | AMOUNT | NONE | NO | NO |
| SYS | V_ORDERS_CTX | GROUP_REGION | POLICY_DYNAMIC | AMOUNT | NONE | NO | NO |
+--------------+----------------+--------------+----------------+----------------+---------------+--------+-----------+
2 rows in set
References
Query information about all columns associated with policies in the tables or views owned by the current user: USER_SEC_RELEVANT_COLS
Query information about all columns associated with policies in the tables or views accessible to the current user: ALL_SEC_RELEVANT_COLS