How to Delete a User in Oracle
Connect to Oracle database with any administrator user which has 'drop user' permissions., Run command 'drop user '., Alternatively run command 'drop user cascade'.
3 Steps
1 min read
Easy
Step-by-Step Guide
-
Step 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). -
Step 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. , This command will drop user as well as all the schema objects created by this user. -
Step 3: Alternatively run command 'drop user<user-name-to-be-dropped> cascade'.
Detailed Guide
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.
About the Author
N
Nathan Rogers
A passionate writer with expertise in hobbies topics. Loves sharing practical knowledge.
45 articles
View all articles
Rate This Guide
--
Loading...
5
0
4
0
3
0
2
0
1
0
How helpful was this guide? Click to rate: