Delete a User Account in Oracle

Q

How To Delete a User Account in Oracle?

✍: FYIcenter.com

A

If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example:

>.\bin\sqlplus /nolog

SQL> connect SYSTEM/fyicenter
Connected.

SQL> DROP USER DEV CASCADE;
User dropped.

SQL> CREATE USER DEV IDENTIFIED BY developer ACCOUNT UNLOCK;
User created.

Note that CASCADE tells the server drop the associated schema.

 

Privilege Needed to Connect to Oracle Server in Oracle

Change User Password in Oracle

Managing Oracle User Accounts, Schema and Privileges

⇑⇑ Oracle Database Tutorials

2019-07-09, 1633🔥, 0💬