OK, I've managed to confuse myself ... again.
User MOE has developed an uncomplicated table on the DEV
database. He wants users LARRY and CURLY, both members of the
STOOGES role, to be able to access the table from the PROD
database.
We make the table available to the PROD database through a
PUBLIC database link. MOE grants SELECT to PUBLIC on his table.
Back on the PROD database, we create a public synonym for the
table (CREATE PUBLIC SYNONYM PRATFALLS FOR MOE.PRATFALLS@DEV).
Now we ask LARRY and CURLEY to SELECT COUNT(*) FROM PRATFALLS
... And they get the message, "TABLE DOES NOT EXIST".
What am I doing wrong?
Regards,
Gus
