About Audit Records

原创 2008年10月03日 10:58:00
导读:

About Audit Records


Audit records include information about the operation that was audited, the user who performed the operation, and the date and time of the operation. Depending on the type of auditing you choose, you can write audit records to data dictionary tables, called the database audit trail, or in operating system files, called the operating system audit trail.


If you choose to write audit records to the database audit trail, Oracle Database writes the audit records to the SYS.AUD$ table for default and standard auditing, and to the SYS.FGA_LOG$ table for fine-grained auditing. Both of these tables reside in the SYSTEM tablespace and are owned by the SYS schema. You can check the contents of these tables by querying the following data dictionary views:




  • DBA_AUDIT_TRAIL for the SYS.AUD$ contents



  • DBA_FGA_AUDIT_TRAIL for the SYS.FGA_LOG$ contents



  • DBA_COMMON_AUDIT_TRAIL for both SYS.AUD$ and SYS.FGA_LOG$ contents


"Finding Information About Audited Activities" describes more data dictionary views that you can use to view to contents of the SYS.AUD$ and SYS.FGA_LOG$ tables.


If you choose to write audit records to an operating system file, you can write them to either a text file or to an XML file. You can check the contents of an audit XML file by querying the V$XML_AUDIT_TRAIL data dictionary view.



本文转自
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/auditing.htm

Oracle:ORA-28056: Writing audit records to Windows Event Log failed

出现此错误的原因是系统的日志记录存放满了,新的日志记录写不进去了,所以报错!...
  • wangfayinn
  • wangfayinn
  • 2016年01月27日 17:58
  • 1676

解决方法之ora-28056: Writing audit records to Windows Event Log failed

sqlplus  /  as  sysdba 登录时,出现以下提示: ORA-28056: Writing audit records to Windows Event Log failed ...
  • haiross
  • haiross
  • 2014年03月19日 17:27
  • 1224

ORA-28056: Writing audit records to Windows Event Log failed解决办法

一般遇到这个问题,很大可能就是非正常关机,或者非正常停止oracle数据库,解决办法如下: 1.开始-cmd进入dos窗口,然后输入sqlplus/nolog,正常sql*plus的信息; 2.接...
  • yangchengsong
  • yangchengsong
  • 2013年03月05日 10:45
  • 618

Audit Records

If you are creating an audit record, there are normally three fields that need to go at the start of...
  • WTK870424
  • WTK870424
  • 2011年12月14日 22:13
  • 298

ORA-28056:Writing audit records to Windows EventLog failed

sqlplus / as sysdba的时候 提示ORA-28056:Writing audit records to Windows EventLog failed 提示 ORA-28056:W...
  • aoc212
  • aoc212
  • 2013年10月16日 14:49
  • 333

Writing audit records to Windows Event Log failed

C:\Documents and Settings\Administrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Producti...
  • iamzj85
  • iamzj85
  • 2015年02月06日 14:27
  • 296

Oracle Audit 功能的使用方法介绍

收藏... 一. 视图说明:1. SYS.AUD$审计功能的底层视图,如果需要对数据进行删除,只需要对aud$视图进行删除既可,其他视图里的数据都是由aud$所得.2. DBA_AUDIT_EXIST...
  • sopost
  • sopost
  • 2009年10月11日 18:34
  • 9909

Audit Login 导致死机的原因

最近客户反应,系统会出现3-5分钟的集体死机情况,用sqlserver跟踪分析器查看,发现一个login out 占用了十几分钟的系统时间。目前还没找到问题的根源,在网上收到一些描述:在网上找到临时解...
  • fanghong1999
  • fanghong1999
  • 2007年10月22日 14:11
  • 4031

solve: vmware audit:backlog limit exceeded

sudo vi /etc/selinux/config change SELINUX=disable
  • kcetry
  • kcetry
  • 2016年10月11日 11:54
  • 1212

Oracle数据报错:ORA-28056:Writing audit records to Windows EventLog failed

 ORA-28056:Writing audit records to Windows EventLog failed 系统日志满了,先把系统日志清一下。右键“我的电脑”--‘管理’--事件查...
  • luxiuhao1988
  • luxiuhao1988
  • 2014年09月24日 17:14
  • 260
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:About Audit Records
举报原因:
原因补充:

(最多只允许输入30个字)