Re: privileges won't work through a Role

This is a WAD (working as designed) and partly changes in Oracle 8(i).

Roles are not enabled during stored procedures because pl/sql procedures are compiled, at compile time the privileges are checked, and roles are fluent. There is no guarantee it'll work in the future , you could have changed your role.
In Oracle 8i it is possible to call a procedure with definer rights or invoker rights.
This should resolve your problem.
Refer to http://osi.oracle.com/~tkyte for further details.

Regards,

Sybrand Bakker, Oracle DBA

Michael Cooke <mick_at_cook161.freeserve.co.uk> wrote in message news:8b8eqj$hq9$1_at_newsg3.svr.pol.co.uk...
> Oracle 7.3.3.0.0 NT4 SP3
>
> I have a problem with certain tables in that when I usse then in a role
 and
> grant the role to a user they get the 'insufficient privileges' error,
> however when I grant the user the same privileges explicitly (not as part
 of
> a role) everything is ok. only applies to certain tables for which
 specific
> users have privs other than select.
>
> Has anyone come accross this problem - or am I missing something
 blindingly
> obvious.
>
> THis is becoming an anoyance as I have to make sure the group of users get
> updated as they idnetify each 'insufficient privileges' problem.
>
> Thanks in advance for any help
> Mick
>
>
Received on Tue Mar 21 2000 - 00:00:00 CST