Saturday 19 August 2017

ORA-01031: insufficient privileges when creating table

Issue

Create table command fails with below mentioned error 
ERROR at line 1:
ORA-01031: insufficient privileges

Here are the list of privileges granted 

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

Resolution

Grant the below mentioned privileges to the user then re login to database. Now execute the create table statement, it must run successfully. In case you face any issue, please write the comment below
SQL> grant resource to hr;

Grant succeeded.

No comments:

Post a Comment