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
|
|
|
Re: Audit logs [message #452173 is a reply to message #452166] |
Tue, 20 April 2010 07:58 |
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 |
|
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
|
|
|