How to Delete a User in Oracle

Connect to Oracle database with any administrator user which has 'drop user' permissions. Connection to Oracle database can be either via program (through application) or manual (through SQLplus or any equivalent utility).

Run command 'drop user '. This command will simply drop the user without deleting any data created by this user.

Alternatively run command 'drop user cascade'. This command will drop user as well as all the schema objects created by this user.

Original news source