Auditing Question

From: <amerar_at_iwc.net>
Date: Fri, 08 Jun 2007 12:11:45 -0700
Message-ID: <1181329905.286511.96470@h2g2000hsg.googlegroups.com>

Hi,

We have a situation here where I've been asked to audit the database for queries or DML on tables with an 'email' column, for a specific email address. So, when any DML is done to the record containing that email address, or any select is done on that record, write the info to a file or table on the who, when, what, etc.

The DML is easy, actually I can do that using triggers. However, I really have no clue on how to audit select statements. Is this FGA? I thought that was more for security.........

Can anyone help, or point me in the right direction. I'm not looking to read the Oracle manual from start to finish. I'm hoping that someone else has done this and can give me a few instructions.

Thanks in advance!! Received on Fri Jun 08 2007 - 14:11:45 CDT