Re: access to dbms_fga package on shared server

On 5/12/08 3:30 PM, fitzjarrell@[EMAIL PROTECTED]
 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.