How to Delete a User in Oracle

Last Updated: May 6, 2021

Authorized applications or database administrators may need to drop any Oracle user. This article demonstrates how an Oracle user can be dropped from database.

Steps

1
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).
2
Run command 'drop user <user-name-to-be-dropped>'. This command will simply drop the user without deleting any data created by this user.

Advertisement
3
Alternatively run command 'drop user<user-name-to-be-dropped> cascade'. This command will drop user as well as all the schema objects created by this user.