Re: Public synonym not working?

On Mon, 15 Jan 2001 19:52:15 GMT, philo_at_radix.net (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?

...because I had another (empty) table by the same name in the DBA schema.

Sorry.

Philo Received on Mon Jan 15 2001 - 21:02:17 CET