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