Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Delete a User Account
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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.
2007-05-02, 6856👍, 0💬
Popular Posts:
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL Transaction iso...
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
How to measure functional software requirement specification (SRS) documents? Well, we need to defin...
What is normalization? What are different types of normalization? It is set of rules that have been ...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...