Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges

JhilMay 7 2015 — edited May 7 2015

Hi all;

U1> grant references on u1.emp to scott;

Grant succeeded.

SCOTT>alter table u1.emp modify(emp_id number constraint  emp_c1_pk_eid  primary key);

alter table u1.emp modify(emp_id number constraint emp_c1_pk_eid primary key)

*

ERROR at line 1:

ORA-01031: insufficient privileges

To create  primary key or foreign key into  other's object , what privilege should i need ?

Thanks

This post has been answered by unknown-7404 on May 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2015
Added on May 7 2015
8 comments
4,017 views