OraFAQ Forum: SQL & PL/SQL » fk between table on different schema

Home » SQL & PL/SQL » SQL & PL/SQL » fk between table on different schema

Wed, 13 August 2003 09:50

Mat
Messages: 22
Registered: November 2001

Junior Member

How can i create a foreign key between table on different schema? I obtain "ORA-01031: insufficient privileges" error, with a DBA user! Thanks

Wed, 13 August 2003 11:35

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

The owner of the referenced table will need to:

SQL>grant references on t to user_creating_fk;

Thu, 14 August 2003 02:27

Mat
Messages: 22
Registered: November 2001

Junior Member

Great!! Thank you very much.

Previous Topic:	Test Date
Next Topic:	How to insert a clob column via Sql*Plus

Goto Forum:

]

Current Time: Wed Apr 24 18:41:05 CDT 2024