privileges won't work through a Role

From: Michael Cooke <mick_at_cook161.freeserve.co.uk>
Date: 2000/03/20
Message-ID: <8b8eqj$hq9$1@newsg3.svr.pol.co.uk>#1/1

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 Mon Mar 20 2000 - 00:00:00 CST