This IS documented in Oracle documentation (I believe it's in PL/SQL Developer's
Guide) - roles are disabled when compiling stored procedures. There's no way
around this on 7.3. 8i (and 8.0?) added invoker rights stored procedures (aka
AUTHID CURRENT_USER), for which roles are active when they are executed
(but still disabled when they are initially compiled.) This question in various
forms pops up approximately once a week here, so it's a common problem and
I believe every Oracle FAQ has an answer to it. :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"michael.cooke" <michael.cooke_at_tinyworld.co.uk> wrote in message
news:3d2dff93_1_at_mk-nntp-1.news.uk.worldonline.com...
> Currently running Oracle 7.3.3 NT4 SP3
> Developer 2000 Forms 4.5 reports 2.5
> have come across aa couple of occurences where table privileges will not
> work in a role only when granted directly to the user.
> has anyone else come across this problem? is it documented any where? or is
> it likely to be a problem with our application?
>
> thanks for any constructive suggestions
>
>
Received on Mon Jul 15 2002 - 04:45:29 CDT
