Home » RDBMS Server » Security » Auditing Problem . Pls help me
Auditing Problem . Pls help me [message #20425] Thu, 23 May 2002 01:33 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10702
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.
Previous Topic: default passwords
Next Topic: Important Security level
Goto Forum:
  


Current Time: Thu May 26 16:44:45 CDT 2022