Oracle Database Discussions

Hi,

I am having two user operapps and oper

owner of table po_vendors is operapps ,i have created a synonym in oper with select permission.

now i am trying to create a foreign key.

ALTER TABLE OPS_BR_VENDORS ADD ( FOREIGN KEY (VENDOR_ID) REFERENCES PO_VENDORS (VENDOR_ID));

the bolded po_vendors is the synonym for the table po_vendors in operapps.

i am getting the below error message.

SQL> ALTER TABLE OPS_BR_VENDORS ADD ( FOREIGN KEY (VENDOR_ID) REFERENCES PO_VENDORS (VENDOR_ID));
ALTER TABLE OPS_BR_VENDORS ADD ( FOREIGN KEY (VENDOR_ID) REFERENCES PO_VENDORS (VENDOR_ID))
*
ERROR at line 1:
ORA-01031: insufficient privileges.

i have given dba privileges to oper user.

Please advice.