Hi,
Recently, Oracle University posted on his Facebook's wall a question:
You created a new user on the database by executing the following command:
SQL> CREATE USER user01 IDENTIFIED BY user01
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
Then you granted the following privileges to user01
by executing the following command:
SQL> GRANT CREATE SESSION, CREATE TABLE TO user01;
Which statement is true in this scenario?
1. The user can connect to the database
2. The user will be able to create a table
3. The user will be able to query tables only
4. The user will not be able to create a table if
DEFAULT_PERMANENT_TABLESPACE is not set
After many comments with possible correct answers (most of people said 1 and 2), Oracle University replied: Many conflicting opinions here - the correct answer is #4 - The user will not be able to create a table if DEFAULT_PERMANENT_TABLESPACE is not set.
My question is.. WHY 4? Why not 1? Because the user can connect to the database. Also 2 is correct! It can create a table, but having no quota assigned, he cannot insert data into the table. So why 1 and 2 are not correct?