RE: AUDIT sql command question
- From: "Ted Coyle" <oracle-l@xxxxxxxxxxxx>
- To: <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Aug 2007 16:20:26 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Lyndon Tiu
Sent: Thursday, August 09, 2007 4:04 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
