Re: public synonyms

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1999/01/26
Message-ID: <36ADC345.BA2A53D2_at_hk.super.net>#1/1


Have you granted SELECT ON AAA TO your userid?

Mindaugas Vieraitis wrote:

> 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.com

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer
Received on Tue Jan 26 1999 - 00:00:00 CET

Original text of this message