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, 1591🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...