There is a known Bug in Oracle 8.0.3 SQLPLUS. The public synonyms don't
work. There are a couple of work arounds. You can specify sys.v$session,
etc. or create private synonyms for the data dictionary views. Or upgrade
to 8.0.4 or better 8.0.5.
Kenny Gump
OCP 7.3 DBA
Van Messner wrote in message ...
>Running Oracle Server 8.03 Enterprise Ed. on NT 4sp3
>Server and client both on same machine using a bequeath connection.
>I created database, then ran catalog.sql and catproc.sql
>I created a user JOE and granted him every role and permission.
>in SQL+ as system/manager ran pupbld.sql
>in SQL+ as JOE ran catdbsyn.sql
>Using enterprise manager I can see all the data dictionary views and
>their public synonyms. The views are valid.
>views owned by SYS public synonym
> gv_$session gv$session
> all_objects all_objects
> v_$version v$version
>BUT
>in SQL+ as sys/sys
>desc gv_$session gives a proper description of the view
>whereas desc gv$session gives
>ERROR:
>ORA-24332: invalid object type
>Why can't sys see the public synonyms?
>JOE can't either. The only difference is that he has to qualify the
>underlying view with owner sys in order to see them.
>What am I missing here? Thanks.
>
>
>
Received on Mon Jan 11 1999 - 13:05:53 CST
