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.
2019-07-09, 739👍, 0💬
Popular Posts:
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...