Re: public synonyms

From: <jlee_at_tyc.com>
Date: 1999/01/27
Message-ID: <78o369$p2m$1@nnrp1.dejanews.com>#1/1

Did you specify the owner of the table?

create public synonym AAA for user.AAA

user = the user name who created AAA.

If not, you need to drop the public synonym and recreate it again.

In article <36AC6D62.FC532514_at_nomagiclt.com>, Mindaugas Vieraitis <mindaugas_at_nomagiclt.com> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 27 1999 - 00:00:00 CST