OraFAQ Forum: Security

Home » RDBMS Server » Security » Audit logs (Oracle 10g)

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

Audit logs [message #452166]

Tue, 20 April 2010 07:48

ten_lrt
Messages: 3
Registered: December 2009

Junior Member

I have a requirement of implementing audit logs in my application. Insert,update,delete operations can be logged using triggers. How to audit logs in case of Read / Select operation on tables ? Is there any specific way of implementing audit logs for Read operation on tables ?

Thanks in advance

Report message to a moderator

Re: Audit logs [message #452173 is a reply to message #452166]

Tue, 20 April 2010 07:58

John Watson
Messages: 8978
Registered: January 2010
Location: Global Village

Senior Member

Fine Grained Auditing can audit SELECT, implement it with DBMS_FGA. It will do your DML auditing, too.

Report message to a moderator

Re: Audit logs [message #452176 is a reply to message #452166]

Tue, 20 April 2010 08:10

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And, without speaking about FGA, why not using the old AUDIT?

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle VPD
Next Topic:	audit the logs for selecting particular column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 03:52:29 CDT 2025