title: Alter session set current_schema privilege
body: <p>Basicly i have an java application that uses oracle as a data source. Now my application connects with a user and uses connected user's schema for table creation and etc...</p>
  
  <p>Now i have a requirment that my application also should work under another schema.</p>
  
  <p>So i have to alternatives.</p>
  
  <p>1 - Change my table names with a prefix like</p>
  
  <pre><code>select * from other_schema.table
  </code></pre>
  
  <p>2 - Altering the session before running any query like</p>
  
  <pre><code>alter session set current_schema=other_schema
  </code></pre>
  
  <p>I am curios about is there any possibilty that alter session privilege can be revoked by dba's. </p>
  
  <p>Oracle documentation says that </p>
  
  <blockquote>
    <p>You do not need any privileges to perform the other operations of this statement unless otherwise indicated.</p>
    
    <blockquote>
      <p><a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_2012.htm" rel="nofollow">https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_2012.htm</a></p>
    </blockquote>
  </blockquote>
  
  <p>Please note that my app user will have all privileges for <strong>other_schema</strong>.</p>
  
  <p>My application will be running many envoriments.</p>
  
  <p>So going with first appoach, it looks like more safe but it can take long time.</p>
  
  <p>Second one is faster but seems like tricky.</p>