Oracle 视图 DBA_STMT_AUDIT_OPTS 官方解释，作用，如何使用详细说明
本站中文解释
DBA_STMT_AUDIT_OPTS是一个数据库视图，它包含了所有正在使用的Oracle数据库审计选项的详细信息，包括受监控的模式、表，用户和特定语句的类型、操作类型以及特定的操作选项。它可以用来检查正在运行的审计选项，以及审计未正确存储的信息，也可以用来检查需要启用的语句审计事件是否已经被定义并正确激活。要查看DBA_STMT_AUDIT_OPTS视图，可以执行以下SQL语句：
SELECT *
FROM DBA_STMT_AUDIT_OPTS
WHERE AUDIT_OPTION ‘NONE’;
官方英文解释
DBA_STMT_AUDIT_OPTS describes current system auditing options across the system and by user.
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 |
|---|---|---|---|
|
|
|
User name if by user auditing; |
|
|
|
|
Name of the proxy user which is performing an operation for the client; NULL if the client is performing the operation directly |
|
|
|
|
|
Name of the system auditing option |
|
|
|
Mode for |
|
|
|
|
Mode for |
