Re: inter references from one schema to another

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 21 Sep 2004 16:19:21 -0400
Message-ID: <mZadnfNdaal9Ec3cRVn-jw@comcast.com>

"Rayan Yellina" <rayan.yellina_at_gmail.com> wrote in message news:3b6586a.0409211209.6d391054_at_posting.google.com...
| Hi,
| 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] . 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;

| Thank you,
| -Rayan.

yes, and yes -- but grant must be done when connected as 'schema2' (owner of object) and grant must be made directly to the user (schema) creating the FK constraint (i.e., not granted via a role)

++ mcs Received on Tue Sep 21 2004 - 15:19:21 CDT