Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
DROP SEQUENCE to ROLLBACK, 9 of 20
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::=
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.
CASCADE
, the materialized views can no longer be refreshed.
DROP
USER
Example
If user Sidney's schema contains no objects, you can drop sidney
by issuing the statement:
DROP USER sidney;
If Sidney's schema contains objects, you must use the CASCADE
clause to drop sidney
and the objects:
DROP USER sidney CASCADE;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|