Re: FGA
Date: Tue, 12 Aug 2008 00:53:50 -0700 (PDT)
Message-ID: <59820365-e014-4980-9f13-63bbac009268@t54g2000hsg.googlegroups.com>
On Aug 11, 11:18 pm, "Matthias Hoys" <a..._at_spam.com> 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: 10.2.0.3.
>
> 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