oracle9.2.0.3 audit help!!!!!!!
- From: "Artur M." <miodusza@xxxxx>
- Date: Mon, 27 Feb 2006 20:30:17 +0100
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.
.
- Follow-Ups:
- Re: oracle9.2.0.3 audit help!!!!!!!
- From: Sybrand Bakker
- Re: oracle9.2.0.3 audit help!!!!!!!
- Prev by Date: Re: Performance problem with Oracle server
- Next by Date: Re: oracle9.2.0.3 audit help!!!!!!!
- Previous by thread: schedule rman backup in EM 10G
- Next by thread: Re: oracle9.2.0.3 audit help!!!!!!!
- Index(es):
Relevant Pages
|