The USER2 has no his own schema objects and he just want to access the USER1's schema. When USER2 accesses USER1'object, he always needs to prefix USER1 to the object name (For Example, select * from USER1.table1).
My question is: is there any way to set USER1's schema as the default schema for USER2, so USER2 doesn't need to use the prefix any more?
I don't want to use synonym as USER1's schema could be dynamic.
in old days we used private synonyms for every user. If have see case designer for example of this.
now alter session set current_schema is officialy available.
At least I am considering to use this approach inb future applications .