RE: Foreign Key to different schema?

That was it. Thanks!

Side Note: It's pretty cool that all you have to do is 'grant references'. You DO NOT need to 'grant select' as well. So even though one schema can reference and validate its data against another schema, it CANNOT actually SEE it. Good security. Point to Oracle.

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Cyril
> Thankappan
> Sent: Monday, November 27, 2000 7:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Foreign Key to different schema?
>
>
>
> Hi!
>
> Please grant 'references' privilege to
> schema owner of table containing the child table
> (table on which the foreign key is being defined)
>
> grant references on primary_key_table to schema_owner_of_child_table;
>
>
> ------------- Original Message --------------
> Glenn Travis <Glenn.Travis_at_wcom.com> wrote:
> To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> From:Glenn Travis <Glenn.Travis_at_wcom.com>
> Date:Tue, 21 Nov 2000 13:20:26 -0800
> Subject:Foreign Key to different schema?
>
> Is it possible to define a foreign key on a table which references a table
> in a different schema? I tried but got 'insufficient privs' error.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glenn Travis
> INET: Glenn.Travis_at_wcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
> Participate in crazy auctions at http://auctions.rediff.com/auctions/
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Nov 27 2000 - 14:04:32 CST