From: Xbricklen@yahoo.comX   
      
   tracy wrote:   
      
   > I not sure if i posted to the rite group, but hope somebody can help.   
   >   
   > as i know, system is the superpower user in oracle database.  He can   
   > views everything, including role created by others DBA.   
   >   
   > My problem is when i connect as oracle, i unable to view roles created   
   > by dba_01. unless i conncet as dba_01.   
   >   
   > Can somebody tell me , what's wrong?   
   >   
   >   
   > thanq!!   
   SYS is the Supreme Being....   
      
   Try prefixing your queries for dba_01's objects with that username:   
   eg. select * from dba_01.table_name;   
      
   (or grant dba privs etc to oracle user --> generally not a good idea)   
      
   etc etc   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)