RE: benefits of proxy user

From: Kenneth Naim <kennaim_at_gmail.com>
Date: Wed, 30 Sep 2009 12:23:17 -0400
Message-ID: <00b201ca41ea$51f67720$f5e36560$_at_com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 30 2009 - 11:23:17 CDT