Home » RDBMS Server » Security » audit problem (audit problem)
audit problem [message #535047] Mon, 12 December 2011 00:43 Go to next message
hemant_khandare
Messages: 65
Registered: November 2011
Member
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
muralikri
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: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you restart the instance after changing the audit_trail parameter?

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


Current Time: Wed Aug 27 20:32:12 CDT 2014

Total time taken to generate the page: 0.12467 seconds