Oracle 8 and public synonyms

I am experiencing a interesting effect with Oracle 8.04 under NT 4.0. I am unable to
describe public synonyms created by sys or system from other users without specifiying
the user name.

example: As sys: create public synonym user_tables for user_tables;

as user foo: describe user_tables --- no such object; desc sys.user_tables -- ok

select * from user_tables --> works, I get my table list.

create synonym user_tables for sys.user_tables ; desc user_tables === works fine...

Anyone else experienced this?

TIA, Kevin Received on Wed Jun 03 1998 - 12:29:27 CDT