From: <>
Date: Tue, 12 Aug 2008 00:53:50 -0700 (PDT)
Message-ID: <>

On Aug 11, 11:18 pm, "Matthias Hoys" <> wrote:
> I have a question about fine-grained auditing.
> One of our developers asked if it was possible to audit all insert, delete
> and update statements on all tables in a specific schema. The auditing
> information should then be made available for viewing to a specific user. I
> was thinking of using FGA. However, after reading the docs, it's not clear
> to me if you can do this kind of action for a complete schema. Do you have
> to configure FGA for all tables and all columns individually ?
> Version:
> Thanks
> Matthias

Update: I think we can just use the standard audit trail features, like AUDIT DELETE ON ...
FGA is too detailed in this case.

Matthias Received on Tue Aug 12 2008 - 02:53:50 CDT

Original text of this message