Re: roles + pl/sql

  • From: Tim Hall <tim@xxxxxxxxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • Date: Mon, 20 Dec 2010 17:47:17 +0000

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


Other related posts: