在Oracle SQL Developer中创建表时权限不足 [英] Insufficient Privileges when creating tables in Oracle SQL Developer
问题描述
我已授予用户使用sql +(grant create table to <my_user>
)创建表,触发器,过程和序列的权限;但是,这仍然不允许我在该架构中创建一个显示错误消息的表:
I have granted the user in my connection to create tables, triggers, procedures, and sequence using sql+ (grant create table to <my_user>
); however, that still does not allow me to create a table in that schema showing the error message:
java.sql.sqlsyntaxerrorexception ora-01031权限不足
java.sql.sqlsyntaxerrorexception ora-01031 insufficient privileges
select * from session_privs;
显示:
PRIVILEGE
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
有人知道我在这里做错了吗?我只是在家里设置pl/sql开发人员,所以一切都是全新的.这和TABLESPACE
有什么关系吗?
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;
GRANT RESOURCE to my_user;
这篇关于在Oracle SQL Developer中创建表时权限不足的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!