AUDIT sql command question

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 09 Aug 2007 13:03:52 -0700
Message-Id: <200708092003.l79K3qTZ012979@rm-rstar.sfu.ca>

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 Received on Thu Aug 09 2007 - 15:03:52 CDT