AUDIT sql command question
- From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 09 Aug 2007 13:03:52 -0700
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
- Follow-Ups:
- RE: AUDIT sql command question
- From: Ted Coyle
Other related posts:
- » AUDIT sql command question
- » RE: AUDIT sql command question
- » AUDIT sql command question
- » Re: AUDIT sql command question
- » RE: AUDIT sql command question
- » Re: AUDIT sql command question
- » RE: AUDIT sql command question
- » Re: AUDIT sql command question
- » RE: AUDIT sql command question
- » RE: AUDIT sql command question
- » RE: AUDIT sql command question
- » Re: AUDIT sql command question
- RE: AUDIT sql command question
- From: Ted Coyle