title: Grant Select on all Tables Owned By Specific User
body: <p>I need to grant select permission for all tables owned by a specific user to another user.  Can I do this with a single command along the lines of:</p>
  
  <pre><code>Grant Select on OwningUser.* to ReceivingUser
  </code></pre>
  
  <p>Or do I have to generate the sql for each table with something along the lines of:</p>
  
  <pre><code> Select 'GRANT SELECT ON OwningUser.'||Table_Name||'TO ReceivingUser' 
   From All_Tables Where Owner='OWNINGUSER'
  </code></pre>