OraFAQ Forum: Security » audit problem

Home » RDBMS Server » Security » audit problem (audit problem)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

audit problem [message #535047]

Mon, 12 December 2011 00:43

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.

Report message to a moderator

Send a private message to this user

Re: audit problem [message #535049 is a reply to message #535047]

Mon, 12 December 2011 00:59

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Try this one

SELECT * FROM audit_actions

Report message to a moderator

Send a private message to this user

Re: audit problem [message #535066 is a reply to message #535047]

Mon, 12 December 2011 01:35

Michel Cadot
Messages: 54155
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you restart the instance after changing the audit_trail parameter?

Regards
Michel

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 22:40:37 CDT 2013

Total time taken to generate the page: 0.09899 seconds