title: Is it possible to view Oracle user table privileges without having DBA privilege?
body: <p>Is it possible to view the roles of the user without having DBA Privilege? If so, how?</p>
  
  <pre><code>SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'USER_NAME';
  </code></pre>
  
  <p>The above query needs the "SELECT_CATALOG_ROLE" role.</p>
  
  <p>I need to get the result of the above query without (DBA and SELECT_CATALOG_ROLE) Privileges.</p>