Remember, roles do work with PL/SQL if you use invoker rights (AUTHID CURRENT_USER). It is only when using owner rights (AUTHID DEFINER) they do not work. Cheers Tim... On Mon, Dec 20, 2010 at 5:25 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > I'd agree with the dev. Role based access is just the right thing to do. > PL/SQL is often* the correct thing to do. It's mad that a php app has a > better access control model (roles) than a PL/sql based one.<rant> > > *where often >= 95% of the time :) > > On 20 Dec 2010 17:16, "Stephens, Chris" <Chris.Stephens@xxxxxxx> wrote: > > I just went through the ‘roles are not active in pl/sql’ speech with a > developer. > > > > His response was that someone at Oracle really needs to fix that. > > > > My first reaction was ‘I’m sure there is a very good reason for it to be > that way’ but I can’t really think of why it is that way. > > > > Are roles disabled in pl/sql for some reason other than that’s just the way > oracle implemented it? > > > > chris > > CONFIDENTIALITY NOTICE: > This message is intended for the use of the individual or entity to which it > is addressed and may contain information that is privileged, confidential > and exempt from disclosure under applicable law. If the reader of this > message is not the intended recipient or the employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by email reply. > > > -- //www.freelists.org/webpage/oracle-l