Re: access to dbms_fga package on shared server
Date: Mon, 12 May 2008 16:03:22 +0200
Message-ID: <48284e2b$0$41662$4fafbaef@reader4.news.tin.it>
On 5/12/08 3:30 PM, fitzjarrell_at_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. Received on Mon May 12 2008 - 09:03:22 CDT