title: How can I enumerate the list of privileges granted to an Oracle role?
body: <p>I have a homegrown Oracle role that was created long ago:</p>
  
  <pre><code>create role MyRole;
  </code></pre>
  
  <p>It's been granted the ability to select, insert, update, and delete from some tables and views.</p>
  
  <pre><code>grant select on sometable to MyRole;
  grant insert on sometable to MyRole;
  grant select on someothertable to MyRole;
  -- etc.
  </code></pre>
  
  <p>How can I now enumerate the specific list of privileges that were granted to the role?  I am interested in discovering the specific tables and the rights this role has with respect to each table.  How can I recover this information?</p>