Oracle 视图 STMT_AUDIT_OPTION_MAP 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图STMT_AUDIT_OPTION_MAP是一个管理视图，它把审计选项和对应的操作映射起来，用来支持DBMS_FGA 包相关的函数和存储过程的参数和传出参数。
使用方法：
1. 首先，使用此视图来查询触发器和权限操作的映射关系：
SELECT option_value, privilege_class, privilege_type
FROM STMT_AUDIT_OPTION_MAP;
2. 其次，使用此视图来匹配一个操作到一个对应的数据库对象，比如表名或者视图名等：
SELECT option_name, option_value
FROM STMT_AUDIT_OPTION_MAP
WHERE object_name = ‘my_table_name’;
官方英文解释
STMT_AUDIT_OPTION_MAP describes auditing option type codes. This table can be used to map auditing option type numbers to type names.
Note:
This view is populated in any Oracle Database where auditing is enabled, regardless of whether pre-Oracle Database 12c auditing or unified auditing is enabled for the 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.
Note:
The mapping explained in this view is valid for audit configuration from the DBA_STMT_AUDIT_OPTS view only, and such audit configurations can be made when unified auditing is not enabled.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Numeric auditing option type code |
|
|
|
|
Name of the type of auditing option |
|
|
|
|
Property flag of the auditing option |
See Also:
“DBA_STMT_AUDIT_OPTS”
