Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Constraints with Synonyms?
<SPAN
class=790442712-03042001>Hi,
<SPAN
class=790442712-03042001>
You
s<SPAN
class=790442712-03042001>hould grant REFERENCES privilege on parent table to
owner of child table.
GRANT
REFERENCES on [parent table] to [child table owner]
<SPAN
class=790442712-03042001>
<SPAN
class=790442712-03042001>Gyula
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
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.
Received on Tue Apr 03 2001 - 07:57:39 CDT
![]() |
![]() |