by "fitzjarrell@[EMAIL PROTECTED]
" <oratune@[EMAIL PROTECTED]
>
May 12, 2008 at 08:30 AM
On May 12, 9:03=A0am, maxim2k <maxi...@[EMAIL PROTECTED]
> wrote:
> On 5/12/08 3:30 PM, fitzjarr...@[EMAIL PROTECTED]
wrote:
>
> > I can only presume this access is through the schema owner. =A0Is this
> > the ONLY account accessing this users objects?
>
> Yes, each customer has an Oracle user/schema.
>
> > Which should not be an issue. =A0My question is this: if there is only
> > ONE user account which =A0can access these user objects what good does
> > having execute privilege on dbms_fga provide? =A0This 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.
That depends upon what you want to accomplish with this audit trail,
this may give you some ideas on how to proceed depending upon the
desired result:
http://oratips-ddf.blogspot.com/2006/05/audit-this.html
David Fitzjarrell
