title: Oracle DB - how to display privs across schemas/owners?
body: <p>I have a owner A and owner B in the DB. Each of them has its own schemas, etc. If I grant rights to an user from B (so he has e.g. access to some view under A), is there any way how to display privs like this? I mean, one user has some rights under each DB owner and its schematas.
  The reason for that is that I would need to be sure that no user under B has access to any object under A.
  Thank you very much</p>
  
  <p><strong>EDIT: For more clear question:</strong></p>
  
  <pre><code>Sceham owner A               Schema owner B
  Table X                      Table CC
  Table Y                      Table DD
  View Z                       View EE
  </code></pre>
  
  <p>Now say user John has access to schemas under owner A but also to one view under schema owned by Oracle owner B. How could I list his rights across schemas?</p>