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. :)
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.
> 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