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
答案解析:有
微信扫一扫手机做题