Oracle 视图 ALL_AUDIT_POLICIES 官方解释,作用,如何使用详细说明
ALL_AUDIT_POLICIES视图用于显示所有审核策略的相关信息。它包含每种审核策略的路径名称,采用的审核模式,最后更新日期和是否有效的相关信息,用于查询回的审核策略的列表。
要使用此视图,首先需要创建审核策略,然后对视图进行SELECT查询,查询某个审核策略的相关信息。例如:
SELECT POLICY_NAME, POLICY_MODE
FROM ALL_AUDIT_POLICIES
WHERE POLICY_NAME = MY_AUDIT_POLICY
ALL_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views accessible to the current user.
Note:
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.
See Oracle Database Upgrade
Guide for more information about migrating to unified auditing.
DBA_AUDIT_POLICIES describes all fine-grained auditing policies in the database.
USER_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views owned by the current user. This view does not display the OBJECT_SCHEMA column.
Indicates whether the policy is applied to queries on the object (YES) or not (NO)
Indicates whether the policy is applied to INSERT statements on the object (YES) or not (NO)
Indicates whether the policy is applied to UPDATE statements on the object (YES) or not (NO)
Indicates whether the policy is applied to DELETE statements on the object (YES) or not (NO)
Indicates the audit trail to which the audit records generated by this audit policy will be written:
DB+EXTENDED Audit records are written to DBA_FGA_AUDIT_TRAIL (fine-grained audit trail) and the SQL_TEXT and SQL_BIND columns are populated for this policy
XML+EXTENDED Audit records are written to V$XML_AUDIT_TRAIL (XML audit files) and the SQL_TEXT and SQL_BIND columns are populated for this policy
Indicates whether all columns in the AUDIT_COLUMN parameter (ALL_COLUMNS) or any of the columns in the AUDIT_COLUMN parameter (ANY_COLUMNS) are considered for triggering fine-grained auditing
Indicates whether the policy applies across multiple containers (YES) or not (NO)
Indicates whether the policy was inherited from another container (YES) or not (NO)
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 ALL_AUDIT_POLICIES 官方解释,作用,如何使用详细说明
相关文章
- 快速导入 Oracle 数据库: 使用 Dmp 文件(oracle数据库导入dmp文件)
- Oracle 视图 USER_PARTIAL_DROP_TABS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_SQL_TRANSLATION_PROFILES 官方解释,作用,如何使用详细说明
- Oracle 视图 V$DATAGUARD_PROCESS 官方解释,作用,如何使用详细说明
- 解析Oracle性能:使用这些工具(oracle性能工具)
- Oracle网页管理:一个简单而极其重要的任务(oracle网页管理)
- 使用Oracle变量连接提升数据库性能(oracle变量连接)
- 搞定Oracle时区设置:一步一步来(oracle设置时区)
- 从备份数据库中恢复Oracle表(oracle数据库表恢复)
- 深入了解Oracle查询触发器的作用和使用方法(oracle查询触发器)
- 深入探究Oracle国家字符集的重要性和应用技巧(oracle国家字符集)
- 使用C语言读取Oracle数据库表信息(c 读取oracle表)
- 如何更好地利用Oracle实现CRM系统的卓越管理(crm系统 oracle)
- Oracle存储PDF文档的最佳方法(oracle保存pdf)
- Oracle技术让我们实现更多的可能性(oracle使用了关键字)
- 值Oracle存储位和值的奥妙(oracle 位与)
- Oracle数据库回退提交技巧(oracle中提交回退)
- Oracle中循环的多层嵌套结构分析(oracle中 循环嵌套)
- Oracle中SQl实现相减运算(oracle中sql相减)
- Oracle C共享内存实现数据访问的新方式(oracle c共享内存)
- 使用遗憾Oracle 12不再被支持(oracle 12 停止)
- 如何解决Oracle错误代码01463(oracle 01463)