title: Oracle : Cannot query a view of another schema that also has linked tables to another schema
body: <p>I have a view created under a user "<strong>dbaUserA</strong>". View query uses a table from another user "<strong>dbaUserB</strong>". Both users are dba.</p>
  
  <p>view name: <strong>v_valid_trx</strong>
  with query of</p>
  
  <pre><code> Select trx_no,trx_date,order_item 
   from trx_table a left outer join  dbaUserB.cancelled_trx b on a.trx_no=b.trx_no
   where b.trx_no is null;
  </code></pre>
  
  <p>I have created a less privilege user "<strong>userC</strong>" but with select privilege on </p>
  
  <pre><code>dbaUserA.trx_table
  dbaUserB.cancelled_trx.
  dbaUserA.v_valid_trx
  </code></pre>
  
  <p>I can select directly trx_table and cancelled_trx from those different schemas however i cannot select on the view <strong>v_valid_trx</strong>.</p>
  
  <p>Oracle prompts</p>
  
  <blockquote>
    <p>ORA-01031: insufficient privileges
    01031. 00000 -  "insufficient privileges"
    *Cause:    An attempt was made to change the current username or password
               without the appropriate privilege. This error also occurs if
               attempting to install a database without the necessary operating
               system privileges.
               When Trusted Oracle is configure in DBMS MAC, this error may occur
               if the user was granted the necessary privilege at a higher label
               than the current login.
    *Action:   Ask the database administrator to perform the operation or grant
               the required privileges.
               For Trusted Oracle users getting this error although granted the
               the appropriate privilege at a higher label, ask the database
               administrator to regrant the privilege at the appropriate label. Error at Line: 1 Column: 21</p>
  </blockquote>
  
  <p>Been wrestling with these for hours now. I can't seem to understand the cause of the error when i can freely select the base tables.</p>
  
  <p>please help :) </p>