ORA-01031 Insufficient privileges

5 pts.
Tags:
Foreign keys
ORA-01031
Oracle
Oracle development
Oracle error messages
Primary keys
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

The owner of the table in schema B needs to grant the REFERENCES privilege to the user of schema A.

Example:

<pre>grant references on table_on_schema_b to user_of_schema_a;</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: