Dropping a Database User

When you drop a database user, you also drop all objects owned by the user—that is, all objects in the user's schema.

To drip an existing user account:

On the Database Home Page, click the Administration icon and then Database Users.
If prompted, enter the appropriate administrator username and password and click Login.

The Manage Database Users page appears.
You can locate an existing database user as follows:
- To locate a specific user, type a username or partial string in the Username field and click Go.
- To view all users, leave the Find User field blank and click Go
Select a user.

The User page appears.
Click Drop.
Select Cascade and click Drop User.

A report region appears displaying existing applications and scripts. Applications and scripts associated with the user's account will be deleted when the user account is dropped.

Note:

In order to drop a database user whose schema contains database objects, you must select Cascade. An error will result if you do not select Cascade and the database user's schema contains database objects.