Auditing Problem . Pls help me [message #20425] |
Thu, 23 May 2002 01:33 |
Prathee
Messages: 9 Registered: May 2002
|
Junior Member |
|
|
Hi all,
I have executed Cataudit.sql (as SYS User).
then
I have created a table in my account
create table a(id int);
then I started auditing like
AUDIT ALL ON A BY ACCESS;
After that I have inserted a record into A
like
insert into A values (100);
commit;
But ....
when I searched USER_AUDIT_TRAIL AND SYS.AUD$ TABLE
it is showing
"No Records found".
Why is it so.
Any parameter settings is required ???
Pls help me .
-Prathee
|
|
|
Re: Auditing Problem . Pls help me [message #20430 is a reply to message #20425] |
Thu, 23 May 2002 05:47 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
you need add the initialization parameter
AUDIT_TRAIL = DB
if AUDIT_TRAIL=DB , then oracle enables systemwide auditing where audited records are written to the
database audit trail, the SYS.AUD$ table.
if AUDIT_TRAIL = OS
modify the "init<sid>.ora" file to specify the destination for the audited records using the AUDIT_FILE_DEST parameter.
If your operating system supports AUDIT_TRAIL = OS auditing, files are automatically written to the AUDIT_FILE_DEST for certain actions.
eg:
AUDIT_FILE_DEST = $ORACLE_HOME/rdbms/audit
Note: Windows NT does not use the AUDIT_FILE_DEST parameter. Operating System auditing changes are recorded in the NT Event Viewer.
|
|
|