Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
SQL Statements: DROP SEQUENCE to ROLLBACK, 9 of 19
Use the DROP
USER
statement to remove a database user and optionally remove the user's objects.
See Also:
|
You must have the DROP
USER
system privilege.
drop_user::=
Specify the user to be dropped. Oracle does not drop users whose schemas contain objects unless you specify CASCADE
or unless you first explicitly drop the user's objects.
Specify CASCADE
to drop all objects in the user's schema before dropping the user. You must specify this clause to drop a user whose schema contains any objects.
See Also:
Oracle9i Data Cartridge Developer's Guide for more information on these routines |
If user Sidney's schema contains no objects, then you can drop sidney
by issuing the statement:
DROP USER sidney;
If Sidney's schema contains objects, then you must use the CASCADE
clause to drop sidney
and the objects:
DROP USER sidney CASCADE;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|