What's the privileges to create foreign key to a different schema.table ?
486955Nov 30 2006 — edited Nov 30 2006Hi
In my current schema I want to add a new foreign key. But this key is referencing to a table in a different schema, like this:
Alter table some_table ADD ( Constraint FK_01 Foreign Key (L_ID) References schema.table (LL_ID));
and getting the error - ORA-01031 insufficient privileges
Which privileges do I need for this (At this time, I have only GRANT Select)? Any help would be much appreciated
Best regards
Remo