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_objectdisplays audit trail records for all objects accessible to the current user
网友评论