|
-
synonyms has to be created under schema who is going to QUERY the tables
in your case you are not doing that, you are not importing anything to the user who is querying
imagine
userA is the one who is going to query userB's objects
you import into userB
if userA wants to query userB's tables he has to create private synonyms
unless you import into userA private synonym definitions from other database
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
|