SQL>
SQL> CREATE USER newUserName IDENTIFIED BY password;
User created.
SQL>
SQL> SELECT default_tablespace, temporary_tablespace
2 FROM dba_users
3 WHERE username='NEWUSERNAME';
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM TEMP
SQL>
-- sqlplus newUserName/password
SQL> GRANT CREATE SESSION TO newUserName;
Grant succeeded.
SQL>
SQL> DROP USER newUserName;
User dropped.
SQL>