Re: roles + pl/sql

I do know this, and it actually gives more flexibility, but it still remains the case that oracle's best database based dev tool *by default* rejects sql statements in code that run in sql. Imagine an OS shell where you could test statements interactively that ran just fine, but which when put in a script/program with the same login wouldn't run interactively and you had to explicitly say by the way I can run this. ( selinux/windows UAC) awful.

On 20 Dec 2010 17:47, "Tim Hall" <tim_at_oracle-base.com> wrote:

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_at_gmail.com> wrote:
> I'd agree w...

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