Re: access to dbms_fga package on shared server
- From: "fitzjarrell@xxxxxxx" <oratune@xxxxxxx>
- Date: Mon, 12 May 2008 08:30:53 -0700 (PDT)
On May 12, 9:03 am, maxim2k <maxi...@xxxxxxxxx> wrote:
On 5/12/08 3:30 PM, fitzjarr...@xxxxxxx 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.
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
.
- Follow-Ups:
- Re: access to dbms_fga package on shared server
- From: Mark D Powell
- Re: access to dbms_fga package on shared server
- References:
- Re: access to dbms_fga package on shared server
- From: fitzjarrell@xxxxxxx
- Re: access to dbms_fga package on shared server
- Prev by Date: Re: "desperately tiny" rdbms setup
- Next by Date: Re: "desperately tiny" rdbms setup
- Previous by thread: Re: access to dbms_fga package on shared server
- Next by thread: Re: access to dbms_fga package on shared server
- Index(es):
Relevant Pages
|
