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: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Thu, 8 Jan 2004 23:58:14 +1100
Message-ID: <3ffd53aa$0$18747$afc38c87@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 - 06:58:14 CST












Original text of this message













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