Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Migration/Refresh tool

Re: Migration/Refresh tool

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 09 Jan 2006 15:24:05 -0600
Message-ID: <6sk5s19e70kc14jr3foajbu4k6uhcci9jt@4ax.com>


"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 - 15:24:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US