Insufficient Privileges Create table

Question

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

Answer 1

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.

Answer 2

I tried the chosen answer and it didn't work. When you ask questions just wait until you recieve at least 3 answers and then give it green thick.

Try this instead(run it with sys or system user): 'GRANT RESOURCE to my_user; '

Source & already answered link: Insufficient Privileges when creating tables in Oracle SQL Developer