Differences

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

--- database:oracle:users:connect-as-another-user [2018/09/19 15:26] – created odefta
+++ database:oracle:users:connect-as-another-user [2023/07/04 19:36] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 alter user main_user grant connect through proxy1;
 connect proxy1[main_user]/proxy1@SID;
-<code>
+</code>
 Now we are connected, let's check current user:
@@ Line 16: / Line 16: @@
 user is main_user
-If you want to change only the default schema:
+====== Change only the default schema ======
 <code sql>
 alter session set current_schema=other_schema_name
 </code>
+Check if the schema was changed:
+<code sql>
+select sys_context( 'userenv', 'current_schema' ) from dual;
+</code>