How to Delete or Drop an User in Database

September 27, 2012

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.( 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:

You Might Also Like