Connection to Oracle database can be either via program (through application) or manual (through SQLplus or any equivalent utility).;
, This command will simply drop the user without deleting any data created by this user.
 This command will drop user as well as all the schema objects created by this user.
Connect to Oracle database with any administrator user which has 'drop user' permissions.
Run command 'drop user <user-name-to-be-dropped>'.
Alternatively run command 'drop user<user-name-to-be-dropped> cascade'.
{"src": "wikihow-all_validation", "title": "How to Delete a User in Oracle"}