Public synonym not working?
From: Philo <philo_at_radix.net>
Date: Mon, 15 Jan 2001 19:52:15 GMT
Message-ID: <3a635358.17798943_at_enews.newsguy.com>
Date: Mon, 15 Jan 2001 19:52:15 GMT
Message-ID: <3a635358.17798943_at_enews.newsguy.com>
I'm logged into an oracle database as User1, which has DBA privileges,
as well as a native schema.
select * from table returns no rows
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 user2.table works as it's supposed to
Why isn't the public synonym working?
Philo Received on Mon Jan 15 2001 - 20:52:15 CET