Re: Public synonym not working?
From: Per Dahlén <per.dahlen_at_capgemini.se>
Date: Tue, 16 Jan 2001 09:05:04 +0100
Message-ID: <3A6400B0.79BA4A4E_at_capgemini.se>
Date: Tue, 16 Jan 2001 09:05:04 +0100
Message-ID: <3A6400B0.79BA4A4E_at_capgemini.se>
You have propably created two (or more) synonyms on the table that is accessible from the User1 schema. Check in the dba_synonyms table, to find out if this is the case.
Per DahlĂŠn
Philo wrote:
> I'm logged into an oracle database as User1, which has DBA privileges,
> as well as a native schema.
> There is a table in schema User2 that I want to select from There is a
> public synonym on the table (created by User1).
>
> select * from table returns no rows
> select * from user2.table works as it's supposed to
>
> Why isn't the public synonym working?
>
> Philo
Received on Tue Jan 16 2001 - 09:05:04 CET