Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP on privileges/roles
Running Oracle Server 8.03 Enterprise Ed. on NT 4sp3
Server and client both on same machine using a bequeath connection.
connected as internal created database, then ran catalog.sql and
catproc.sql
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.
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 Fri Jan 08 1999 - 19:23:29 CST