Good afternoon to all
I try to run the code below in XE 11
alter table CUSTOMERS
add constraint CUSTOMERS_ACCOUNT_MANAGER_FK foreign key (ACCOUNT_MGR_ID)
references HR.EMPLOYEES (EMPLOYEE_ID) on delete set null;
the result is
Error report -
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
Thanks in advance
HR owner will have to grant REFERENCES privilege on the EMPLOYEES table to get that DDL to fly ...