How to Delete or Drop an User in Database

    0
    20
    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    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

    Don't miss out!
    Subscribe To Newsletter

    Receive top technical news, lesson ideas, travel tips and more!

    Invalid email address
    Give it a try. You can unsubscribe at any time.

    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here