Hi,
 
I have a need to create a synonym in a schema (A) for a table that is another schema (B). This is no problem. However, the table in question is a "parent" table and I cannot create the "references" constraint from the "child" to the "parent" when the "parent" is a synonym. When I attempt to do so I get an ORA-1031 error (Insufficient Privileges).
 
Is this a known limitation of synonyms or am I missing something here? I find the 1031 error a strange one to receive if this a limitation of synonyms--schema A has DBA role granted to it so the problem shouldn't be one of permissions.
 
Any suggestions/feedback would be appreciated. Thanks!!
-w
 
PS: Recreating the table from schema B in schema A is not an option, unfortunately.

Reply via email to