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: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 08 Jan 2004 11:01:49 GMT
Message-ID: <3FFD3831.F88E4FC1@yahoo.net>


Laurent RUHLMANN wrote:
>
> 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

Are you using Object or System priviledges?

The problem you have seems to relate to object privs. (See Chapter 25 of the 9iR2 DBA manual - topic is too large to discuss here.) Received on Thu Jan 08 2004 - 05:01:49 CST

Original text of this message

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