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

Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign key references a table in an other schema of the database

Re: Foreign key references a table in an other schema of the database

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 8 Jan 2004 08:20:41 -0500
Message-ID: <rvudnUxcS9ixxGCiRVn-gQ@comcast.com>

"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:3ffd53aa$0$18747$afc38c87_at_news.optusnet.com.au...
| "Laurent RUHLMANN" <lruhlmann_at_ingesoft.fr> wrote in message
news:btjb10$ne6$1_at_s1.read.news.oleane.net...
|
| > First, I wish you a happy new year !
|
| 2u2.
|
|
| > I'm trying to create a foreign key in PARTERN references a table of
EXTERN
| > but Oracle tell me tha I have not suffisant privileges. I have tried to
put
| > every privileges possible but nothing to do.
| >
| > Any idea ?
| >
|
|
| CONNECT EXTERN/<password>
| GRANT REFERENCES ON <table> TO PARTERN;
|
| --
| Cheers
| Nuno Souto
| wizofoz2k_at_yahoo.com.au.nospam
|
|

+ 2 cents:

this privilege must be granted directly to the schema that will create the FK reference (as shown) -- it cannot be granted to a ROLE (ORA-01919), except for the PUBLIC role

Received on Thu Jan 08 2004 - 07:20:41 CST

Original text of this message

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