Re: fine-grained auditing

From: <fitzjarrell_at_cox.net>
Date: Fri, 31 Aug 2007 11:18:12 -0700
Message-ID: <1188584292.681279.39620@g4g2000hsf.googlegroups.com>

On Aug 31, 10:55 am, Oraculo01 <cesar.casti..._at_exel.com> wrote:
> > There is also a link to an example in the documentation in the blog
> > entry which should also list the required privileges. You will need
> > to have execute on the dbms_fga package for any of this to work.
>
> > David Fitzjarrell
>
> That's what I was afraid of. I'll ask our DBA.
> Thank you!

Normally when the package is created the necessary permissions are granted to the EXECUTE_CATALOG_ROLE. You may, then, have two problems:

1. the DBMS_FGA package has not been created.
2. the user account creating the FGA policy isn't granted the EXECUTE_CATALOG_ROLE

I agree the smart decision here is to discuss this with your DBA and arrive at a mutually agreeable solution.

David Fitzjarrell Received on Fri Aug 31 2007 - 13:18:12 CDT