CREATE USER {} IDENTIFIED BY "{sth}" DEFAULT TABLESPACE users QUOTA unlimited ON users
GRANT CREATE SESSION TO {}
GRANT CREATE TABLE TO {}
GRANT CREATE VIEW TO {}
GRANT CREATE SEQUENCE TO {}

DROP USER {} CASCADE

SQL> connect sys as sysdba
Enter password:
Connected.
SQL>
SQL> create user creator identified by creator
  2  default tablespace users
  3  temporary tablespace temp
  4  quota unlimited on users;

User created.

SQL> grant create user     to creator;

Grant succeeded.

SQL> grant create session  to creator with admin option;

Grant succeeded.

SQL> grant create table    to creator with admin option;

Grant succeeded.

SQL> grant create view     to creator with admin option;

Grant succeeded.

SQL> grant drop user       to creator;

Grant succeeded.

SQL>

SQL> connect creator/creator
Connected.
SQL> create user dropme identified by dropme;

User created.

SQL> grant create session to dropme;

Grant succeeded.

SQL> grant create table   to dropme;

Grant succeeded.

SQL> drop user dropme;

User dropped.

SQL>