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

本站中文解释

Oracle视图是指为用户提供一个只能查询的虚拟表,是从其他表的数据中提取或显示的特殊表格,属于数据库进阶技术之一,可帮助用户更好地管理数据库。

AUDIT_ACTIONS视图显示每个审计活动的信息,包括启用审计活动或将其禁止的名称,日期,时间以及有关活动的背景信息,这将有助于进行深入的审计活动研究,并改善系统的安全。

要使用AUDIT_ACTIONS视图,可以使用SELECT语句检索其中的数据,例如:

SELECT * FROM audit_actions;

官方英文解释

AUDIT_ACTIONS describes audit trail action type codes. This table can be used to map action type numbers to action type names.

Note:

The mapping explained in this view is valid for audit trail records from the following views only, and such audit records are generated only when unified auditing is not enabled:

  • DBA_AUDIT_TRAIL

  • DBA_COMMON_AUDIT_TRAIL

  • DBA_FGA_AUDIT_TRAIL

  • USER_AUDIT_TRAIL

  • V$XML_AUDIT_TRAIL

Note:

This view is relevant when using traditional auditing. Traditional auditing is deprecated in Oracle Database 21c. Oracle recommends that you instead use unified auditing, which enables selective and more effective auditing inside Oracle Database.

  • See Oracle Database Security
    Guide
    for more information about unified auditing.

  • See Oracle Database Upgrade
    Guide
    for more information about migrating to unified auditing.

Column Datatype NULL Description

ACTION

NUMBER

NOT NULL

Numeric audit trail action type code.

NAME

VARCHAR2(28)

NOT NULL

Name of the type of audit trail action


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