Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 28 of 30
To remove a database user and optionally remove the user's objects. For information on creating a user, see "CREATE USER". For information on modifying the definition of a user, see "ALTER USER".
You must have the DROP
USER
system privilege.
If user BRADLEY's
schema contains no objects, you can drop BRADLEY
by issuing the statement:
DROP USER bradley;
If BRADLEY's
schema contains objects, you must use the CASCADE
clause to drop BRADLEY
and the objects:
DROP USER bradley CASCADE;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|