Re: HELP with Roles/Permissions

Many Thanks. I wish the bug had been known to me. I have 8.05 so I'll do the upgrade.

Van

Kenny Gump wrote in message <369a4bbf.0_at_news.mountain.net>...
>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 - 19:39:06 CST