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.( as ‘xxxx’
    let us delete the user.

    drop user user_name

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

    Ads code goes here
    drop user xxxx

    The output will be–

    The user is dropped

    image credit:

    Share and Enjoy !

    READ  How to Create User in Oracle Database?

    Leave a Comment

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