What is the privilege required to create unique/primary key constraint in Oracle?
granting resource must resolve the issue :
SQL> conn tuser1/tuserp1Connected.SQL> create table tab2 (empno number, name varchar2(30), sal number,constraint pk_tab2 primary key (empno)); create table tab2 (empno number, name varchar2(30), sal number,*ERROR at line 1:ORA-01031: insufficient privilegesSQL> conn / as sysdbaConnected.SQL> grant resource to hr;Grant succeeded.SQL> conn tuser1/tuserp1Connected.SQL> create table tab2 (empno number, name varchar2(30), sal number,constraint pk_tab2 primary key (empno)); Table created.