Collections:
Delete a User Account in Oracle
How To Delete a User Account in Oracle?
✍: FYIcenter.com
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
2019-07-09, 1673🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...