Re: granting problems ...

From: Niall Litchfield <Niall.litchfield_at_dial.pipex.com>
Date: Tue, 27 Sep 2005 18:50:00 +0100
Message-ID: <43398648.4090706@dial.pipex.com>

steph wrote:
> Hi all,
>
> I have a table for which i want to grant select privilige to a group of
> users. Therefore I create a role and grant select on the table to this
> role. Then i grant the role to the users.
>
> I would have expected that my users can now select from this table.
> Nevertheless this is not so. Only when I grant select privilege
> directly to a user this user has access on the table.
>
> I'm sure I make a rather dumb error here, but nevertheless I'm stuck
> with it. Can someone give a hint?
>
> By the way, I'm using Oracle 10g on Linux (if this makes any
> difference)
>
> Thanks,
> Stephan

Can you show us exactly what you are doing by posting the output from a sqlplus session? I can think of at least a couple of different situations that fit what you describe.

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Tue Sep 27 2005 - 12:50:00 CDT