问题:
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.
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?()
● 参考解析
本题暂无解析
相关内容
相关标签