RE: Accessing Synonym

you have to grant that user rights on that specific table

grant select on inventory.table to user;

> -----Oorspronkelijk bericht-----
> Van: Abdul Aleem [SMTP:dmit_at_beaconhouse.edu.pk]
> Verzonden: donderdag 18 april 2002 8:18
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Accessing Synonym
>
> Hi,
>
> I tried to create a public synonym for a table in schema "inventory", but
> it
> does not seem to be working, i.e., when I connect as another user, and try
> to select from the synonym it says table or view does not exist.
>
> I would appreciate any help.
>
> Aleem
>
> Following are the commands from SQL*Plus:
>
> SQL> connect inventory/invent_at_test_server
> <mailto:inventory/invent_at_test_server>
> Connected.
> SQL> create public synonym company for company;
>
> Synonym created.
> SQL> connect scott/tiger_at_test_server <mailto:scott/tiger_at_test_server>
> Connected.
> SQL> select * from company;
> select * from company
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> SQL> select * from inventory.company;
> select * from inventory.company
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
> INET: dmit_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: GKor_at_rdw.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).