you have to grant that user rights on that specific table
grant select on inventory.table to user;
-Oorspronkelijk bericht-
Van: Abdul Aleem [SMTP:[EMAIL PROTECTED]]
Verzonden:donderdag 18 april 2002 8:18
Aan: Multiple recipients of list ORACLE-L
Onderwerp:Accessing
of list ORACLE-L
@beaconhouse.[EMAIL PROTECTED]
edu.pk cc:
Sent by: rootSubject: Accessing Synonym
dmitTo: Multiple recipients of list
ORACLE-L
@beaconhouse.[EMAIL PROTECTED]
edu.pk cc:
Sent by: rootSubject: Accessing Synonym
04/18
Yes, the table exists,
I wasn't giving select privileges to users who would use the table through
synonym.
Thank you for your response.
Aleem
-Original Message-
Sent: Thursday, April 18, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: 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