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: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 8 Jan 2004 12:49:43 +0100
Message-ID: <3ffd4378$0$17144$626a54ce@news.free.fr>

"Laurent RUHLMANN" <lruhlmann_at_ingesoft.fr> a écrit dans le message de news:btjb10$ne6$1_at_s1.read.news.oleane.net...
> Hello,
>
> First, I wish you a happy new year !
>
>
> I'm working with Oracle 9i and I have two schemas on my database. The owner
> of tables in the first schema is PARTERN, the other one is EXTERN.
> 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 ?
>
> Laurent
>

EXTERN have to grant REFERENCES privilege on the referenced table to PATTERN.

Regards
Michel Cadot Received on Thu Jan 08 2004 - 05:49:43 CST

Original text of this message

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