Re: Auditing Question

On Jun 8, 2:11 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> 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!!

You can start here:

http://oratips-ddf.blogspot.com/2006/05/audit-this.html#links

It should give you a start on configuring and using FGA. Then you can read further in the documentation as the need arises.

David Fitzjarrell Received on Fri Jun 08 2007 - 14:40:57 CDT