Insufficient privileges when adding FK constraint (Oracle) Insufficient privileges when adding FK constraint (Oracle) oracle oracle

Insufficient privileges when adding FK constraint (Oracle)


The table with the primary key is owned by a different schema - LAB_ADMIN. That user must grant REFERENCES on TEST_TEMPLATE to LAB_ADMIN_USER.


From the owning schema execute GRANT REFERENCES ON OWNINGSCHEMA.TABLE TO OTHERSCHEMA;