Role problem: Why doesn't this work?

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 Received on Fri Dec 08 2000 - 21:31:15 CST