User Tools

Site Tools


database:oracle:users:connect-as-another-user

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
database:oracle:users:connect-as-another-user [2018/09/19 15:26]
odefta created
database:oracle:users:connect-as-another-user [2018/09/19 15:30] (current)
odefta
Line 5: Line 5:
 alter user main_user grant connect through proxy1; alter user main_user grant connect through proxy1;
 connect proxy1[main_user]/proxy1@SID; connect proxy1[main_user]/proxy1@SID;
-<code>+</code>
  
 Now we are connected, let's check current user: Now we are connected, let's check current user:
Line 16: Line 16:
 user is main_user user is main_user
  
-If you want to change only the default schema:+====== Change only the default schema ======
  
 <code sql> <code sql>
 alter session set current_schema=other_schema_name alter session set current_schema=other_schema_name
 </code> </code>
 +
 +Check if the schema was changed:
 +
 +<code sql>
 +select sys_context( 'userenv', 'current_schema' ) from dual;
 +</code>
 +
 +
  
  
database/oracle/users/connect-as-another-user.1537359995.txt.gz ยท Last modified: 2018/09/19 15:26 by odefta