ORA-01031: insufficient privileges while creating table in database

This document describes about "ORA-01031" issue.

Issue:

SQL> show user
USER is "CHRIS"

SQL> create table target(SNO Number(10), Name Varchar2(10), Salary Varchar2(10));
create table target(SNO Number(10), Name Varchar2(10), Salary Varchar2(10))
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL>


Cause and Solution:

User Chris does not have "CREATE TABLE" privilege to create table. Login as sys and grant "CREATE TABLE" privilege to user CHRIS.

SQL> conn sys as sysdba
Enter password:
Connected.

SQL> show user

USER is "SYS"

SQL> grant create table to chris;

Grant succeeded.

Validation:

SQL> conn chris/welcome

Connected.

SQL> show user

USER is "CHRIS"

SQL> create table target(SNO Number(10), Name Varchar2(10), Salary Varchar2(10));

Table created.

SQL> 

Thanks for your patience to view this post............