You execute the following set of commands to create a database user and to grant the system privileges in
your production environment.
SQL> CREATE USER user01
IDENTIFIED BY oracle
DEFAULT TABLESPACE tbs1
TEMPORARY TABLESPACE temp
PROFILE default
/
SQL> GRANT create session, create table TO user01;
While executing the command to create a table, the user gets the following error message and the CREATE
TABLE.. command fails.
ERROR at line 1:
ORA-01950: no privileges on tablespace
What could be the possible reason for this error message?
A) The tablespace TBS1 is full.
B) The user is not the owner of the SYSTEM tablespace.
C) The user does not have quota on the TBS1 tablespace.
D) The user does not have sufficient system privileges to create table in the TBS1 tablespace.
E) The user does not have sufficient privileges to create table on the default permanent tablespace.
【答案是C。配额不足怎么会显示权限不足，那权限不足显示什么？】
------最佳解决方案--------------------------------------------------------
用户建表不但要有CREATE TABLE的权限，还要在表空间下有足够的配额。
不过ORACLE这个提示似乎有些误导的成份。
------其他解决方案--------------------------------------------------------
不懂，是不是和表空间大小有关系？
------其他解决方案--------------------------------------------------------
谢谢TodayZ的回答，不过为什么D选项是错的呢。
------其他解决方案--------------------------------------------------------
quota on tablespace 不是一种 system privileges。
------其他解决方案--------------------------------------------------------
D：The user does not have sufficient system privileges to create table in the TBS1 tablespace.
但create table是system privilege，不是吗？
------其他解决方案--------------------------------------------------------
SQL> GRANT create session, create table TO user01;
从上面的语句看到user01已经有了 create table的 ystem privileges
------其他解决方案--------------------------------------------------------
TodayZ,你看题很仔细啊，非常感谢。也帮我看看其他的题目，就知道CSDN的兄弟乐于助人啊，感动，结贴，给分。哈哈。。