Example: Modifying a User Account

Suppose you want to remove the quota limitations for the user Nick on his default tablespace, USERS. To do so, you must modify his user account.

To modify the 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 Edit.

   If you do not see user Nick, then he 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 his 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 Edit.

   The Edit User page appears, and displays the general attributes for Nick.

3. Toward the top of the page, select the Quotas subpage.

4. In the Quota column for tablespace USERS, select Unlimited from the list, and then click Apply.

   A message appears, indicating that user Nick was modified successfully.