DROP USER

Drop a user schema including all schema objects (if any).

Syntax:

   DROP USER username [CASCADE]

Specify CASCADE to drop all objects in the user's schema.

"Think of all the beauty still left around you and be happy" - Anne Frank

Related Commands:

CREATE USER
ALTER USER

Related Views:

                                           USER_PASSWORD_LIMITS  
                                                                SESSION_ROLES
                                                                SESSION_PRIVS
                                                                SESSION_CONTEXT
 DBA_TS_QUOTAS                             USER_TS_QUOTAS
 DBA_USERS            ALL_USERS            USER_USERS
 V$SESSION
 V$SESSION_CONNECT_INFO