Re: Role problem: Why doesn't this work?

Well, I granted the role specifically to the user and it works on, however I'm going to need all of my users to have this role so that was why I granted it to Public.

gmei_at_my-deja.com wrote:

> You should grant the role to this "different user" instead of PUBLIC.
>
> Hope this helps.
>
> Guang
>
> In article <3A31A77F.9A445AB1_at_ev1.net>,
> dsscott_at_ev1.net wrote:
> > I created some public synonyms to some tables in a particular schema. I
> > created a role and granted table privileges (select, insert, update &
> > delete) on those tables to the role. I then granted the role to
> > PUBLIC. When I log into SQL*Plus as a different user from the schema
> > with the tables I cannot execute any SQLs against any of the tables.
> > Can anyone tell me why this doesn't work?
> >
> > Douglas Scott
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Dec 10 2000 - 09:47:32 CST