Example: Deleting a User Account

Suppose user Nick has moved to another department. Because it is no longer necessary for him to have access to the database, you want to delete his user account.

You must use caution when deciding to deleting a user account, because this action also deletes all schema objects owned by the user. To prevent a user from logging in to the database while keeping the schema objects intact, lock the user account instead. See "Locking and Unlocking User Accounts".

To delete user Nick: 

1. Go to the Users page, as described in "Viewing User Accounts".

2. In the Select column, select the user account Nick, and then click Delete.

   If you do not see the user account Nick, then it may be on another page. In this case, do one of the following:

   • Just above the list of user accounts, click Next to view the next page. Continue clicking Next until you see the user account for Nick.

   • Use the Search area of the page to search for the user account. In the Object Name field, enter the letters NI, and then click Go.

   You can then select the user account for Nick and click Delete.

   A confirmation page appears.

3. Click Yes to confirm the deletion of the user account.