Home » RDBMS Server » Security » Audit logs (Oracle 10g)
Audit logs [message #452166] Tue, 20 April 2010 07:48 Go to next message
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
Re: Audit logs [message #452173 is a reply to message #452166] Tue, 20 April 2010 07:58 Go to previous messageGo to next message
John Watson
Messages: 8960
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.
Re: Audit logs [message #452176 is a reply to message #452166] Tue, 20 April 2010 08:10 Go to previous message
Michel Cadot
Messages: 68712
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
Previous Topic: Oracle VPD
Next Topic: audit the logs for selecting particular column
Goto Forum:
  


Current Time: Wed Nov 13 01:01:18 CST 2024