Re: Migration/Refresh tool

"Magnus Andersen" <mag.andersen_at_gmail.com> wrote:

>I guess I still don't understand how this would work. I apologize for
>my ignorance. Here is my scenario...
>
>Schemas
>sysadm_a
>sysadm_b
>
>Tables
>sysadm_a.ps_cm_prodcost
>sysadm_b.ps_cm_prodcost
>
>Synonyms
>create synonym ps_cm_prodcost for sysadm_a.ps_cm_prodcost
>create synonym ps_cm_prodcost for sysadm_b.ps_cm_prodcost
>
>When I log into the database as magnus and query ps_cm_prodcost, what
>table will I query and why?
>
>Again, I'm sorry for my ignorance, but I don't understand.
>
>Thanks,
>Magnus

Oracle will not allow duplicate synonym names, so your second statement would fail..

If you were not magnus when you created a synonym, and you did not grant magnus rights to it, you would, as magnus, get a table not found error ( or something similar)..  

Use separate names for the synonyms and grant rights as desired to the user.. Received on Mon Jan 09 2006 - 22:24:05 CET