Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> public synonyms
I've created the public synonym on (let's say) AAA table. This synonym has the same name as and the table. Then I connected as the different user and tried to retrieve inofrmation from AAA table: select * from aaa;
But I've got the message: ORA-00942: table or view does not exist.
I know that the public is the schema, which can by accessed by every
user in the database.
So, why I cannot access this table AAA?
Thank you.
-- Mindaugas Vieraitis programmer No Magic, Inc. Elektrenu 8-409 Kaunas, 3000 Lithuania e-mail: mindaugas_at_nomagiclt.comReceived on Mon Jan 25 1999 - 00:00:00 CST