RE: AUDIT sql command question

From: Ted Coyle <oracle-l_at_webthere.com>
Date: Thu, 9 Aug 2007 16:20:26 -0400
Message-ID: <000601c7dac2$b962a9b0$3921a8c0@medecision.com>

Unless you clear aud$ it, I don't think it goes away.

That would be a loophole in the audit wouldn't it?

Subject: How to Truncate, Delete, or Purge Rows from the Audit Trail Table SYS.AUD$

  	Doc ID: 	Note:73408.1 	Type: 	BULLETIN
  	Last Revision Date: 	06-OCT-2006 	Status: 	PUBLISHED

-T

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyndon Tiu
Sent: Thursday, August 09, 2007 4:04 PM
To: oracle-l_at_freelists.org
Subject: AUDIT sql command question

RE:

---

AUDIT
Purpose
Use the AUDIT statement to:

Track the occurrence of SQL statements in subsequent user sessions. You can track the occurrence of a specific SQL statement or of all SQL statements authorized by a particular system privilege. Auditing operations on SQL statements apply only to subsequent sessions, not to current sessions. Track operations on a specific schema object. Auditing operations on schema objects apply to current sessions as well as to subsequent sessions.

---

No where in the docs does it state how far into the past the audit trail keeps a record of what happened to the database object being audited.

Does anyone here have an idea?

Thanks.

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 09 2007 - 15:20:26 CDT