This shows you the differences between two versions of the page.
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 | + | ====== Change |
<code sql> | <code sql> | ||
alter session set current_schema=other_schema_name | alter session set current_schema=other_schema_name | ||
</ | </ | ||
+ | |||
+ | Check if the schema was changed: | ||
+ | |||
+ | <code sql> | ||
+ | select sys_context( ' | ||
+ | </ | ||
+ | |||
+ | |||