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

本站中文解释

Oracle视图ALL_UNIFIED_AUDIT_ACTIONS可用于处理审计数据。其中包含Oracle数据库集成审计服务记录的所有活动信息。ALL_UNIFIED_AUDIT_ACTIONS视图记录了实例名称、活动开始时间、活动结束时间、活动的结果(如失败或成功)、活动的用户名和发起活动的IP地址等信息。

可以使用ALL_UNIFIED_AUDIT_ACTIONS视图来监控系统活动,检查用户是否正常登录,检查特定的用户是否发出不正当的请求。另外,它还可以用来检查系统是否出现不正常活动,以及用户是否合法地访问资源数据。

官方英文解释

ALL_UNIFIED_AUDIT_ACTIONS describes unified audit trail actions.

The actions described in this view are valid for audit trail records from the UNIFIED_AUDIT_TRAIL view. Such records are generated only when unified auditing is enabled.

See Also:

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

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

Column Datatype NULL Description

TYPE

NUMBER

NOT NULL

Numeric component type for system wide actions

COMPONENT

VARCHAR2(64)

NOT NULL

Name of component for system wide actions

ACTION

NUMBER

NOT NULL

Numeric auditable action code for system wide actions

Note: The action code values have changed from Oracle Database release 12.2 to the current release. If your applications have queries that include the ACTION column, and if these queries were written in release 12.2, then be aware that the output may be different if you are running these queries in the current release.

NAME

VARCHAR2(64)

NOT NULL

Name of auditable action

See Also:

“UNIFIED_AUDIT_TRAIL”


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