René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -

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.