Dropping Users


Any users, except for SYS and SYSTEM, can be dropped from the database as long as the user to be dropped is not actively logged on.

The following code drops the user as well as all the user's objects:

 DROP USER username [CASCADE]; 

The CASCADE option drops all the objects in the schema before dropping the user and must be specified if the schema being dropped contains any objects.

If you need to learn about the users in your database, information can, naturally, be found in the data dictionary.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net