Subject:  HOW TO SWITCH YOUR CURRENT SCHEMA 
Creation Date:  11-OCT-1997 

Problem Description 
=================== 

You would like to access objects owned by user 'XYZ' when you are logged
in as a such as 'SCOTT' without specifying "schema.object_name" or using 
synonyms. 
 

Solution Description
====================

Use SET CURRENT_SCHEMA

Note that CURRENT_SCHEMA is not a documented parameter, and therefore its 
functionality could be changed or the parameter could be made unavailable at 
any time.

But this is how it works:

ALTER SESSION SET CURRENT_SCHEMA=:USER_ID;

For example:

If you are logged in as user "SCOTT" and want to access or create objects as 
"TOM" but don't want to specify the schema or use synonyms each time, then 
you would simply alter our current schema by:

ALTER SESSION SET CURRENT_SCHEMA=TOM;

This would allow you to access or even create objects in the schema 'TOM' 
provided you have the correct privileges.


Solution Explanation:
=====================

CURRENT_SCHEMA only alters the current schema and allows you to access objects 
in another schema, provided you have the privilege to do so.


References
==========

- This is undocumented parameter, and functionality could
  change any time.

          
Search Words:
============= 

[switch schema], 
[switch current schema], 
[current schema], 
current_schema