How to Delete a User in Oracle
How to Delete a User in Oracle
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 '. 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

What's your reaction?

Comments

https://tupko.com/assets/images/user-avatar-s.jpg

0 comment

Write the first comment for this!