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: 72
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.

Report message to a moderator

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

Report message to a moderator

Re: audit problem [message #535066 is a reply to message #535047] Mon, 12 December 2011 01:35 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you restart the instance after changing the audit_trail parameter?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:16:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.