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 Oracle 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