Oracle 视图 USER_AUDIT_POLICY_COLUMNS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图USER_AUDIT_POLICY_COLUMNS用于查询数据库中定义的用户审计策略中各列的详细信息。包括此策略所应用的用户列和列属性,如列名,数据类型和其他属性。

使用方式:可以使用SELECT语句从视图中检索数据,如:

SELECT POLICY_NAME, COLUMN_NAME, ACTION_TYPE FROM USER_AUDIT_POLICY_COLUMNS;

这将检索出系统中定义的所有审计策略的名称,列名以及它们所应用的动作类型。

官方英文解释

USER_AUDIT_POLICY_COLUMNS describes the fine-grained auditing policy columns on the tables and views owned by the current user. Its columns are the same as those in ALL_AUDIT_POLICY_COLUMNS.

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.

See Also:

“ALL_AUDIT_POLICY_COLUMNS”


数据运维技术 » Oracle 视图 USER_AUDIT_POLICY_COLUMNS 官方解释,作用,如何使用详细说明