Download Article
Download Article
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
-
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 <user-name-to-be-dropped>'. This command will simply drop the user without deleting any data created by this user.Advertisement
-
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.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- Drop user may take time as it has to delete all user data.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Thanks to all authors for creating a page that has been read 77,572 times.
Advertisement