Scenario:
you want to create a cross-schema Foreign key constraint:
ALTER TABLE JIM.TRANSACTION
ADD ( CONSTRAINT TRANSACTION_FK
FOREIGN KEY (TRANS_ID) REFERENCES
DWIGHT.TRANSACTION_HISTORY(TRANS_ID)
);
In order to accomplish this, user JIM needs the REFERENCES system privilege on DWIGHT's table:
GRANT REFERENCES ON DWIGHT.TRANSACTION_HISTORY TO JIM;
No comments:
Post a Comment