How to Delete or Drop an User in Database

Share and Enjoy !

I have described here how to create an user in database.But I have got a question how to delete an user.

Well for this operation a database admin who is a higher level user can create and delete users.
Or else a user having admin privilege can do this operation.

In my last post I have created one user.(https://www.techtravelhub.com/2012/09/how-to-create-user-in-oracle-database.html) as ‘xxxx’
let us delete the user.


drop user user_name




Herethe user name is ‘xxxx’ so the query will be



drop user xxxx



The output will be–

The user is dropped

image credit: http://webindiasolutions.com/blog/wp-content/uploads/2011/11/3D_Data_Base.jpg

Share and Enjoy !

READ  How to Create User in Oracle Database?

Leave a Reply

Your email address will not be published. Required fields are marked *