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 Sy
Aleem
edu.pk> cc:
Sent by: rootSubject: Accessing Synonym
04/18/2002
02:18 AM
Please
respond to
edu.pk> cc:
Sent by: rootSubject: Accessing Syno
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
> Onderwer
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*P