How to Delete a User in Oracle

PDF download Download Article
PDF download Download Article

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

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0a\/Delete-a-User-in-Oracle-Step-1.jpg\/v4-460px-Delete-a-User-in-Oracle-Step-1.jpg","bigUrl":"\/images\/thumb\/0\/0a\/Delete-a-User-in-Oracle-Step-1.jpg\/aid1919489-v4-728px-Delete-a-User-in-Oracle-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Connection to Oracle database can be either via program (through application) or manual (through SQLplus or any equivalent utility).
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b1\/Delete-a-User-in-Oracle-Step-2.jpg\/v4-460px-Delete-a-User-in-Oracle-Step-2.jpg","bigUrl":"\/images\/thumb\/b\/b1\/Delete-a-User-in-Oracle-Step-2.jpg\/aid1919489-v4-480px-Delete-a-User-in-Oracle-Step-2.jpg","smallWidth":460,"smallHeight":307,"bigWidth":480,"bigHeight":320,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    This command will simply drop the user without deleting any data created by this user.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Delete-a-User-in-Oracle-Step-3.jpg\/v4-460px-Delete-a-User-in-Oracle-Step-3.jpg","bigUrl":"\/images\/thumb\/3\/3d\/Delete-a-User-in-Oracle-Step-3.jpg\/aid1919489-v4-640px-Delete-a-User-in-Oracle-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":640,"bigHeight":480,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    This command will drop user as well as all the schema objects created by this user.
    4. Advertisement


Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      Advertisement

      You Might Also Like

      How to
      Delete Duplicate Records in Oracle
      How to
      Install Oracle Java on Ubuntu Linux
      How to
      Install or Remove an RPM Package
      The Ultimate Guide to Using Microsoft Access
      How to
      Learn Data Entry
      2 Ways to Import Data from the Web into Excel: Windows & Mac
      How to
      Add Data to a Pivot Table
      How to
      Reset SA Password in SQL Server
      How to Make an Inventory Database in Access: Complete Guide
      How to
      Make a Database Using MS Access
      How to Order Alphabetically in SQL
      How to
      Hack a Database
      How to
      Link Tables in Access
      How to
      Create a Database from an Excel Spreadsheet
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 76,469 times.

      Is this article up to date?

      Advertisement