Oracle教程

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

本站中文解释

Oracle视图 ALL_DEF_AUDIT_OPTS 是用来视图系统级别的默认的审核选项的汇总。这个视图也可以用来查看特定实体的审核选项，只需要将实体类型和实体名作为查询条件传递给ALL_DEF_AUDIT_OPTS视图。

例如，可以使用以下查询来查询用户SCOTT所具有的默认审核选项：

SELECT * FROM ALL_DEF_AUDIT_OPTS
WHERE object_type = ‘USER’
AND object_name = ‘SCOTT’;

这个视图还可以用来查询运行某个操作所需的特定审核权限。只需要将操作名称和操作类型作为查询条件传递给ALL_DEF_AUDIT_OPTS视图。

例如，可以使用以下查询来查询运行一个SELECT操作所需的审核权限：

SELECT * FROM ALL_DEF_AUDIT_OPTS
WHERE object_type = ‘SELECT’
AND object_name = ‘SELECT’;

官方英文解释

ALL_DEF_AUDIT_OPTS contains default object-auditing options that will be applied when objects are created.

The output for each column takes one of the following forms:

  • -/-: no default auditing

  • S/-: auditing whenever successful

  • -/S: auditing whenever not successful

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.

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.

Column Datatype NULL Description

ALT

VARCHAR2(3)

Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL

AUD

VARCHAR2(3)

Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL

COM

VARCHAR2(3)

Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL

DEL

VARCHAR2(3)

Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL

GRA

VARCHAR2(3)

Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL

IND

VARCHAR2(3)

Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL

INS

VARCHAR2(3)

Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL

LOC

VARCHAR2(3)

Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL

REN

VARCHAR2(3)

Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL

SEL

VARCHAR2(3)

Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL

UPD

VARCHAR2(3)

Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL

EXE

VARCHAR2(3)

Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

FBK

VARCHAR2(3)

Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL

REA

VARCHAR2(3)

Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL


数据运维技术 » Oracle 视图 ALL_DEF_AUDIT_OPTS 官方解释，作用，如何使用详细说明
分享到：

相关推荐