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, 1596🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...