Thank you very much. It is clear now.
-Rayan.
Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<hq31l0t7vmq6sarfqlavrn6qgmg4tnquk3_at_4ax.com>...
> On 21 Sep 2004 13:09:08 -0700, rayan.yellina_at_gmail.com (Rayan Yellina) wrote:
>
> > I am a SQL SERVER guy (new to Oracle). This question might be
> >obvious for you guys. The question is....
> > Is it possible to have a foreign key constraint
> >[schema1.tableA.field] referencing a [schema2.tableB.field] .
>
> Yes.
>
> >I mean
> >it is referencing the table in another schema.
> >If yes, then is this below privillege sufficient
> >grant references to schema2.tableA to schema1;
>
> Yes, but don't you mean:
>
> grant references ON schema2.tableB to schema1;
> ^^ ^
>
> ('on' not 'to', tableB not tableA)
>
> By the way, what happened when you tried this on your copy of Oracle?
Received on Wed Sep 22 2004 - 09:34:53 CDT
