oracle-databaseoracle-sqldevelopercreate-tableora-01031

Insufficient Privileges Create table

I am new with Sql Developer and I got this problem. I make connection but when I try to create table it shows me error:

ORA-01031: Insufficient Privileges.

I try to find answer but I did not succeed.

Please help enter image description here

Solution

  • you or your dba should logon sys, and issue :

    SQL> grant create any table to anonymous;

    OR

    SQL> grant create table to anonymous;

    OR

    SQL> grant resource to anonymous;

    to have creating table privilege.

    the difference between create table and create any table is that

    if you have create table privilege then you can create a table in your own schema.but if you have create any table system privilege then you can create table in any schema.also to create an external table the valid privilege is create any table if you use create table then it will show an error.