ORA-01950: no privileges on tablespace 'USERS'

概述问题描述：对一张新增的表进行insert *** 作，提示没有 *** 作权限，简单的记录一下 解决方案：grant resource to username grant resource to username 时

问题描述：对一张新增的表进行insert *** 作，提示没有 *** 作权限，简单的记录一下

解决方案：grant resource to username　　grant resource to username 时 自动获得了有unlimited tablespace的系统权限

sql> create table jobs(job_ID varchar2(10) primary key,job_Title varchar2(35) not null,min_salary number(6),max_salary number(6));

table created.

sql> insert into values('PRD','程序员',5000,10000);
insert into values('PRD',10000)
*
ERROR at line 1:
ORA-00903: invalID table name

sql> insert into jobs values('PRD',10000);
insert into jobs values('PRD',10000)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

sql> show user
USER is "SYS"
sql>
sql>
sql> grant insert on jobs to user01;
grant insert on jobs to user01
*
ERROR at line 1:
ORA-00942: table or vIEw does not exist

sql> grant insert on user01.jobs to user01;

Grant succeeded.

sql> conn user01/410526
Connected.
sql> insert into jobs values('PRD',10000)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

sql> grant resource to user01;

Grant succeeded.

sql> insert into jobs values('PRD',10000);

1 row created.

总结

以上是内存溢出为你收集整理的ORA-01950: no privileges on tablespace 'USERS'全部内容，希望文章能够帮你解决ORA-01950: no privileges on tablespace 'USERS'所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。