Home » RDBMS Server » Security » audit problem (audit problem)
audit problem [message #535047] Mon, 12 December 2011 00:43 Go to next message
Messages: 72
Registered: November 2011
I enabled audit in my database bye setting audit_trail=db
in parameter file ,but still not able to track all
changes ie changes are not reflecting in Dba_Audit_Trail table or any other table .

I also fired command to audit
"audit delete on dept by access" but still not able to capture all log information.

kindly suggest.
Re: audit problem [message #535049 is a reply to message #535047] Mon, 12 December 2011 00:59 Go to previous messageGo to next message
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Try this one
SELECT * FROM audit_actions
Re: audit problem [message #535066 is a reply to message #535047] Mon, 12 December 2011 01:35 Go to previous message
Michel Cadot
Messages: 61966
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you restart the instance after changing the audit_trail parameter?

Previous Topic: how to enable auditing in oracle
Next Topic: trace or audit user activity
Goto Forum:

Current Time: Tue Oct 13 12:44:54 CDT 2015

Total time taken to generate the page: 0.13295 seconds