Editing Existing User Accounts

Workspace administrators can edit existing user accounts.

To edit an existing user account:

1. Navigate to the Workspace home page.

2. From the Administration list, click Manage Application Express Users.

   The Manage Application Express Users page appears. You can control how the page displays using the navigation bar at the top of the page. See "About the Navigation Bar".

3. Select a user.

   The Edit User page appears.

4. Under Edit User, update the username or email address.

5. Under Password, edit the current password by typing a new password in the Password and Confirm Password fields.

6. 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 and 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.

7. 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".

   
   

8. 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.

9. Under Additional Attributes, update the user's name or add descriptive information about the user or account.

10. Click Apply Changes.

About the Navigation Bar

A navigation bar displays at the top of the Manage Application Users page.

Description of the illustration nav_bar_users.gif

The Manage Application Users page navigation bar contains the following controls:

• Find. Use the Find field to search for an specific user. Enter a case insensitive query and click Go.

• Show. Select the type of user account to view and click Go. Options include:

  • All Accounts

  • Expired Accounts

  • Locked Accounts

  • Unlocked Accounts

  • My Account

  • Developer Accounts

• View. Select a display mode and click Go. Display options include:

  • 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 indicates an expired account.

  • 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.

• Display. Select the number of users to display on the page and click Go.