-
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.
zm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|