FAQ
If the directory isn't already there, you can just create it. On my systems, I set the init.ora parameter
audit_file_dest to a directory like $ORACLE_BASE/admin/SID/audit. On 10, I've noticed that the
default is $ORACLE_BASE/admin/SID/adump, so that might be a good place to start.


I have audit_trail = DB on my systems, and then the audit records are in a SQL-queryable table called
SYS.AUD$. There are a bunch of predefined views of this table (like DBA_AUDIT_TRAIL) that make it very easy to query.


Cheers,
Mike


Michael P. Vergara Be good and you will be lonesome
Oracle Database Administrator Mark Twain

(951) 914-2000 (Voice)
(951) 914-2990 (FAX)

www.guidant.com <http://www.guidant.com/>


From: oracle-l-bounce_at_freelists.org On Behalf Of Chirag DBA
Sent: Wednesday, September 28, 2005 12:33 PM
To: askdba_at_freelists.org; Oracle-L Freelists
Subject: Audit Trail

Hi,


I want to enable simple auditing on my database.


I have started with audit_trail = OS, but the audit directory in ORACLE_HOME/rdbms is not created.


I have run the cataudit.sql.


I know that oracle does basic auditing and puts them in rdbms/audit folder.


This is windows on 9i. Any idea ???


Regards - Chirag

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 5 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 28, '05 at 2:34p
activeSep 28, '05 at 2:56p
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase