Home > IT Answers > Oracle > ORA-01031 Insufficient privileges
SRDBA
5 pts.
0
Q:
ORA-01031 Insufficient privileges
ORA-01031, Foreign keys, Primary keys, Oracle development, Oracle foreign keys, Oracle primary keys, Oracle error messages
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages
ASKED: Jun 16 2009  6:51 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29340 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The owner of the table in schema B needs to grant the REFERENCES privilege to the user of schema A.

Example:

grant references on table_on_schema_b to user_of_schema_a;
Last Answered: Jun 16 2009  2:14 PM GMT by Carlosdl   29340 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0