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: Laurent RUHLMANN <lruhlmann_at_ingesoft.fr>
Date: Thu, 8 Jan 2004 14:16:28 +0100
Message-ID: <btjlbf$b3s$1@s1.read.news.oleane.net>


Thank you

"Noons" <wizofoz2k_at_yahoo.com.au.nospam> a écrit dans le 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
>
>
Received on Thu Jan 08 2004 - 07:16:28 CST

Original text of this message

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