DROP USER
DROP USER user‑name
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the DROP USER statement to remove a specified user from the database.
All the objects associated with the specified user must be dropped prior to using this statement; the DROP USER statement is not a cascaded operation.
Example
DROP USER HOBBES;
Go up to