On 5/12/08 3:30 PM, fitzjarrell@cox.net wrote:
> I can only presume this access is through the schema owner. Is this
> the ONLY account accessing this users objects?

Yes, each customer has an Oracle user/schema.

> Which should not be an issue. My question is this: if there is only
> ONE user account which can access these user objects what good does
> having execute privilege on dbms_fga provide? This is used to provide
> Fine-Grained Access (fga) to database objects based upon a user id.
> If only ONE user id accesses these objects I can see no purpose in
> granting access to this package.

I think the customer needs to create an audit log of actions performed
over database objects. Is there a way to do that without using the
dbms_fga package?

Thanks.