Re: access to dbms_fga package on shared server

From: maxim2k <>
Date: Mon, 12 May 2008 16:03:22 +0200
Message-ID: <48284e2b$0$41662$>

On 5/12/08 3:30 PM, 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. Received on Mon May 12 2008 - 09:03:22 CDT

Original text of this message