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

From: <gmei_at_my-deja.com>
Date: Sat, 09 Dec 2000 04:03:17 GMT
Message-ID: <90sau4$ode$1@nnrp1.deja.com>

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 Fri Dec 08 2000 - 22:03:17 CST