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

Both sides previous revision Previous revision
database:oracle:users:connect-as-another-user [2018/09/19 15:26]
odefta
database:oracle:users:connect-as-another-user [2018/09/19 15:30] (current)
odefta
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.1537360008.txt.gz ยท Last modified: 2018/09/19 15:26 by odefta