drop user [Oracle SQL]

drop user username;
drop user username cascade;

drop user deletes a user.

If the user to be dropped still has either tables, types, triggers and indexes, the user can only be deleted (dropped), if the cascade modifier is specifed. Otherwise, an ORA-01922: CASCADE must be specified to drop 'username' will be issued.