SQL>
SQL>
SQL> create user dropme
2 identified by doomed
3 default tablespace users
4 temporary tablespace temp
5 quota unlimited on users
6 /
User created.
SQL>
SQL> grant create session, create table
2 to dropme
3 /
Grant succeeded.
SQL>
SQL> drop user dropme;
User dropped.
SQL>
SQL>