oracle杀死进程时权限不足,在Oracle SQL Developer中创建表时权限不足

I have granted the user in my connection to create tables, triggers, procedures, and sequence using sql+ (grant create table to ); however, that still does not allow me to create a table in that schema showing the error message:

java.sql.sqlsyntaxerrorexception ora-01031 insufficient privileges

select * from session_privs; shows:

PRIVILEGE

UNLIMITED TABLESPACE

CREATE TABLE

CREATE CLUSTER

CREATE SEQUENCE

CREATE PROCEDURE

CREATE TRIGGER

CREATE TYPE

CREATE OPERATOR

CREATE INDEXTYPE

Does anybody know what I am doing wrong here? I am just setting up pl/sql developer at home, so everything is brand new. Does this have anything to do with TABLESPACE?

解决方案

Run the following command from a privileged user and re-connect with your user:

GRANT RESOURCE to my_user;