Alter session set current_schema privilege
<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>