Re: Insufficient privileges error
Date: Sat, 9 Feb 2002 16:59:26 -0500
Message-ID: <3c659c4b_at_172.22.1.229>
Joe,
Yes, I've recently battled this. Basically, privileges need to be directly granted to be useful by PL/SQL. This is even true in the case where you use AUTHID syntax available in 8i and above. Also, this applies when you construct dynamic SQL or PL/SQL via DBMS_SQL.
Regards,
-Dan
http://www.compuware.com/products/numega/dbpartner/dbpordebug.htm
Debug PL/SQL and Java in the Oracle Database
"Joe Mellors" <joemellors_at_aol.com> wrote in message
news:53566469.0202081611.2123c6a_at_posting.google.com...
> > when PL-SQL code is executed, priviliges granted through roles
> > is 'lost' and that only directly granted priviliges have effect.
>
> Thanks for your help Jon. What you say would explain a lot. The only
> thing I'm wondering now is whether roles are disabled in all pl/sql
> blocks or just in some. I might do a couple of experiments at work
> next week to check this out !
>
> Regards,
>
> Joe Mellors
Received on Sat Feb 09 2002 - 22:59:26 CET