|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.