Editing Existing User Accounts

Workspace administrators can edit existing user accounts.

To edit an existing user account:

Navigate to the Workspace home page.
From the Administration list, click Manage Application Express Users.

The Manage Application Express Users page appears.
To display the page in a different format, make a selection from the View list and click Go:
- Icons (the default) displays each user as a large icon. Different colors indicate the user role, and a lock indicates a locked account. An hourglass, which indicates an expired password, displays when you create a new user account and specify that the new user must change passwords on first use.
- Details displays each user as a line in a report. To expand the report, select the Show Additional Report Columns check box and click Go.
From the Manage Application Express Users page, you can also do the following:
- To narrow the list, select a subset of accounts from the Show list and click Go.
- To search for a user, enter a case insensitive query in the Find field and click Go.
Select a user.

The Edit User page appears.
Under Edit User, update the username or email address.
Under Password, edit the current password by typing a new password in the Password and Confirm Password fields.
Under Developer Privileges:
- Accessible Schemas (null for all) - Enter a colon-delimited list of schemas for which this developer has permissions when using the SQL Workshop. This list of schemas restricts the user to a subset of the full set of schemas provisioned for the workspace and determines what schema names the user sees in SQL Workshop.
- Default Schema - Identifies the default schema used for data browsing, application creation, and SQL script execution.
- Specify the privileges for this user:
  - User is a developer - Developers create and modify applications and database objects as well as view developer activity, session state, workspace activity, application, and schema reports.
  - User is a workspace administrator - In addition to having developer privileges, workspace administrators can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services.
Under Account Control:
- Account Availability - Select Locked to prevent a user from logging in to this account. Select Unlocked to enable the account to be used.
- Developer/Administrator Password and End User Password - Shows the a status of either valid or expired. A password expires when its lifetime span passes.
- Expire Password - Select this option to force the user to enter a new password the next time they log in. This option does not appear for invalid accounts or for workspaces not using the password expiration/account locking functionality.
- Require Change of Password on First Use - Select Yes to require the user to change the password immediately after logging in with the current, temporary password.
  
  This rule applies to the use of this account for developers and workspace administrators. It also applies to all users who use this account when logging in to developed applications.
Tip:
An Oracle Application Express administrator can configure these settings for an entire Oracle Application Express instance. See "Configuring Security Settings".
Under User Groups, select an optional user group.

You can use groups to restrict access to various parts of an application. Groups are primarily useful when using Application Express Authentication.
Under Additional Attributes, update the user's name or add descriptive information about the user or account.
Click Apply Changes.