Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8 and public synonyms
Kevin,
This is a bug in SqlPlus. If you try this in svrmgrl, you shouldn't have
this problem. I thought the fix was supposed to be in 8.0.4, but maybe not
for NT. Even though you can't describe the tables, you should be able
select from them without the owner prefix.
HTH,
Mike Quist
Kevin Barnes wrote in message <357587F7.EA0D1F_at_airmail.net>...
>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 Tue Jun 09 1998 - 10:04:57 CDT