Example: Modifying a User Account

You can use Oracle Enterprise Manager Database Express (EM Express) 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. In EM Express, go to the Users page, as described in "Viewing User Accounts".

  2. Select the user account NICK, and from the Actions menu, select View Details.

    The View User page appears, with the Privileges & Roles subpage displayed.

  3. Click the Quotas subtab.

    The Quotas subpage appears.

  4. Select tablespace USERS and then click Edit.

    The Alter Quota page appears.

  5. In the Quota field, enter Unlimited.

  6. Click OK.

    A confirmation message appears.