DROP USER

The DROP USER statement is used to remove a user from the Oracle RDBMS and optionally drop all objects owned by that user.

DROP USER username [ CASCADE ];

Example 1:

DROP USER username;

If username owns any objects (ie: tables, views, functions, … in its schema), you must specify CASCADE to drop all of these objects.

Example 2:

DROP USER username CASCADE;