RE: Constraints with Synonyms?

[Andor Gyula]

Hi,   You should grant REFERENCES privilege on parent table to owner of child table. GRANT REFERENCES on [parent table] to [child table owner]   Gyula 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.