Alter session Set Current_Schema=UserXYZ

Using this we can refer to the objects in "SchemaUserX" without any Synonyms or schema reference.

All the objects will be referenced as SchemaUserX.Objectname

Example : select * from tablename

will be transformed to

               Select * from SchemaUserX.tablename;


Statement to execute:


ALTER SESSION SET CURRENT_SCHEMA = SchemaUserX


This will be equivalent to Logging into SchemaUserX and then executing the sql / pl/sql blocks.