oracle9.2.0.3 audit help!!!!!!!

From: Artur M. <miodusza_at_wp.pl>
Date: Mon, 27 Feb 2006 20:30:17 +0100
Message-ID: <dtvjtn$a06$1@atlantis.news.tpi.pl>

I'm new in oracle. I would like to control which user modyficates which tables,etc(mainly jppm by hibernate). I tried to configure audit such way:

    I set value AUDIT_TRAIL = true in
%ORACLE_HOME/admin/<myDatabase>/pfile/%init.ora (it dosen't work. After setting

                    audit for some users, restarting database, and making 

some operations on tables , the default table sys.aud$ was empty)

    I set value AUDIT_TRAIL = db (the same situation)

    I set value

            AUDIT_TRAIL = os

            AUDIT_FILE_DEST= 'C:\audit' ( I didn't see any new log file in that directory )

I have the impression that oracle doesn't write this file during starting.

What did I making wrong ?

Does sombody know diffrent,way to could see past users' operations in database?

Regards.

Artur M. Received on Mon Feb 27 2006 - 13:30:17 CST