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: Pete's <empete2000_at_yahoo.com>
Date: 8 Jan 2004 07:16:30 -0800
Message-ID: <6724a51f.0401080716.7360b6d4@posting.google.com>


"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<3ffd4378$0$17144$626a54ce_at_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

Be sure to grant it directly to the user and not through a role.

HTH,
Pete's Received on Thu Jan 08 2004 - 09:16:30 CST

Original text of this message

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