Differences

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

--- 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] – odefta
@@ 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>