创建表时报错ORA-01950

问题描述:创建表时报错ORA-01950,如下所示:
环境:oracle 11.2.0.4
1、异常重现
sys@ORCL > create tablespace leo_ts datafile '/u01/app/oracle/oradata/orcl/leo_ts01.dbf' size 100m autoextend on extent management local segment space management auto;

Tablespace created.

sys@ORCL > select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/tbs_ogg01.dbf
/u01/app/oracle/oradata/orcl/leo_ts01.dbf

6 rows selected.

sys@ORCL > create user leo identified by leo default tablespace leo_ts temporary tablespace temp;

User created.

sys@ORCL > create table leo.test as select * from dba_objects;
create table leo.test as select * from dba_objects
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'LEO_TS'
2、解决过程
--授予相应权限
sys@ORCL > grant connect,resource to leo;

Grant succeeded.

sys@ORCL 2022-12-15 11:00:49> alter user leo quota unlimited on leo_ts;

User altered.
--此后成功创建表.
sys@ORCL 2022-12-15 11:01:02> create table leo.test as select * from dba_objects;

Table created.