Re: FGA

From: <rgdavi_at_monsanto.com>
Date: Tue, 12 Aug 2008 07:57:03 -0700 (PDT)
Message-ID: <abec9ff4-575e-4993-a00f-0bc7be73bf53@c65g2000hsa.googlegroups.com>


On Aug 12, 2:53 am, matthias.h..._at_gmail.com wrote:
> 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

I agree, standard audit covers this nicely. Received on Tue Aug 12 2008 - 09:57:03 CDT

Original text of this message