有关oracle审计的几个数据字典视图…

 

1.DBA_AUDIT_TRAIL displays all standard audit trail entries. 查看所有的审计记录

2.USER_AUDIT_TRAIL displays the standard audit trail entries related to the current user.查看所有当前用户的审计记录

3.dba_priv_audit_opts查询哪些用户执行了权限审计，包括用户名，执行的系统权限

4.dba_stmt_audit_opts对哪些用户执行了语句审计

5.dba_obj_audit_opts 查看对哪些用户的对象进行了对象统计、

6.DBA_AUDIT_SESSION displays all audit trail records concerning CONNECT and DISCONNECT.

7.USER_AUDIT_SESSION displays the audit trail records concerning connections and disconnections of the current user.

8.sys.aud$存放审计记录的数据字典表，存在system系统表空间中（默认位置为$oracle_base/admin/$oracle_sid/adump/)

9.dba_audit_object displays audit trail records for all objects in the database

10.user_audit_object displays audit trail records for all objects accessible to the current user