Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Thu Apr 18 2002 - 03:08:20 CDT
![]() |
![]() |