Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign key references a table in an other schema of the database
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