Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: granting problems ...
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
![]() |
![]() |