Oracle 视图 ALL_AUDIT_POLICY_COLUMNS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_AUDIT_POLICY_COLUMNS是Oracle系统保存审计策略定义的视图。它会存储当前安装在所有数据库中的审计策略定义。
ALL_AUDIT_POLICY_COLUMNS视图可以帮助DBA了解当前数据库中定义的审计策略情况(如用户，表及部分列审计)。其中含有以下几个字段：
POLICY_NAME：审计策略名称。
POLICY_TYPE：表示当前审计策略的类型，如表审计、行审计等。
AUDIT_OBJECT_NAME：审计对象的名称，如表、用户、行列等。
AUDIT_ACTION_NAMES：审计动作的名称，如SELECT、INSERT等。
COLUMN_NAME：此列审计策略包括被审计的表列。
我们可以使用ALL_AUDIT_POLICY_COLUMNS视图来查看当前环境下审计策略定义，如：
SELECT * FROM ALL_AUDIT_POLICY_COLUMNS;
官方英文解释
ALL_AUDIT_POLICY_COLUMNS describes the fine-grained auditing policy columns on the tables and views accessible to the current user.
Note:
This view is populated only in an Oracle Database where unified auditing is not enabled. When unified auditing is enabled in Oracle Database, the audit records are populated in the new audit trail and can be viewed from UNIFIED_AUDIT_TRAIL.
-
See Oracle Database Security
Guide for more information about unified auditing. -
See Oracle Database Upgrade
Guide for more information about migrating to unified auditing.
Related Views
-
DBA_AUDIT_POLICY_COLUMNSdescribes all fine-grained auditing policy columns in the database. -
USER_AUDIT_POLICY_COLUMNSdescribes the fine-grained auditing policy columns on the tables and views owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the table or view |
|
|
|
|
Name of the table or view |
|
|
|
|
Name of the policy |
|
|
|
|
Relevant column of the policy |
See Also:
-
“DBA_AUDIT_POLICY_COLUMNS”
-
“USER_AUDIT_POLICY_COLUMNS”
