RE: benefits of proxy user
- From: "Kenneth Naim" <kennaim@xxxxxxxxx>
- To: <ganstadba@xxxxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Sep 2009 12:23:17 -0400
One benefit is that the database can identify the ultimate end user so for
example on the rare occasion when a user complains the dba can find the
appropriate session without having to dig through many of them and then take
appropriate action.
Ken
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Michael McMullen
Sent: Wednesday, September 30, 2009 11:16 AM
To: 'ORACLE-L'
Subject: benefits of proxy user
I've read over the documentation after following the recent threads of proxy
users and I'm trying to figure out the benefits. How is it better than
having the owner create packages which control the application and granting
execute on these packages to a web_app user? The web_app user can only
access the app through the package? This is our general approach, or if
people don't like the package approach, then how about the standard least
privilege to a role and the role is granted to a web_app user.
Mike
Other related posts:
