title: How SELECT ANY TABLE privilege work in Oracle?
body: <p>I would like to know how the privilege <code>SELECT ANY TABLE</code> works internally in Oracle.</p>
  
  <p>Is it treated as a single privilege? Or is it equivalent to make a <code>GRANT SELECT ON MyTable TO MyUser</code> for each table?</p>
  
  <p>As example, I would like to know if this work :</p>
  
  <pre><code>GRANT SELECT ANY TABLE TO PUBLIC;
  REVOKE ALL ON MY_TABLE FROM PUBLIC;
  </code></pre>
  
  <p>Would I still have access to <code>MY_TABLE</code> from any user after those queries?</p>