Date: Tue, 12 Aug 2008 07:57:03 -0700 (PDT)
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.
I agree, standard audit covers this nicely. Received on Tue Aug 12 2008 - 09:57:03 CDT