Home » RDBMS Server » Security » Enabling Audit--Urgent
Enabling Audit--Urgent [message #53964] Tue, 22 October 2002 08:20 Go to next message
siva
Messages: 58
Registered: August 1999
Member
Hello ALL,
I want to enable audit .For that I have added a parameter audit_trail=true in initialization parameter file.Along with this I have given an audit sql statement by user.
But I am not able to see any records being inserted into any dictionary views if the sql command is being issued,on which the audit is enabled.
So I request you to say me how to go ahead.This is very urgent.
Re: Enabling Audit--Urgent [message #53965 is a reply to message #53964] Tue, 22 October 2002 08:24 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
did u executed the script file cataudit.sql ...it will create the necessary Tables/Views like dba_stmt_audit_opts, aud$ etc etc

so check it out.

Sai
Re: Enabling Audit--Urgent [message #53990 is a reply to message #53964] Wed, 23 October 2002 03:47 Go to previous message
siva
Messages: 58
Registered: August 1999
Member
Hello Sai,
Thank you for ur reply.But I have executed that yesterday only.But no use.I am getting the same problem.What more settings are required.Can U please give me information.

Regards
Siva
Previous Topic: enable the auditing option for the particular user ?
Next Topic: help audit trail how to set up
Goto Forum:
  


Current Time: Mon Oct 18 06:28:50 CDT 2021