benefits of proxy user
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 30 Sep 2009 11:15:47 -0400
Message-ID: <SNT115-DS13193ABA00D705A70FF3EDA6D40_at_phx.gbl>
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.
Date: Wed, 30 Sep 2009 11:15:47 -0400
Message-ID: <SNT115-DS13193ABA00D705A70FF3EDA6D40_at_phx.gbl>
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-lReceived on Wed Sep 30 2009 - 10:15:47 CDT