title: How to execute query as specific user in Oracle
body: <p>Is there a way to execute a query like</p>
  
  <pre><code>select count(*) from some_table;
  </code></pre>
  
  <p>as a specific user when logged in as a database "super user" like sys or sysadmin?</p>
  
  <p>How can this be accomplished?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>we have where clauses like this:</p>
  
  <pre><code>where column_user_name=user
  </code></pre>
  
  <p>So the DB needs to think the current user as specified by <code>user</code> is the user we want to pretend to be.</p>