Managing Users in an Oracle Application Express Instance

Oracle Application Express administrators can manage all user accounts within an Oracle Application Express instance on the Manage Developers and Users page. User accounts are particularly useful if a workspace utilizes Application Express Authentication.

When setting up user accounts, Oracle Application Express administrators can take advantage of some manageability attributes, such as allowing the accounts to be locked, their password to have a fixed lifetime, and their password to require change on first use.

See Also:

Topics in this section include:

Creating New User Accounts

To create a new user account:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Workspaces.

  3. Under Manage Workspaces, click Manage Developers and Users.

    The Manage Developers and Users page appears.

  4. Click Create.

    The Create/Edit User page appears.

  5. Under User Attributes, enter the appropriate information.

    Tip:

    To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark.

  6. Under Password, type a case-sensitive password for this account.

    If your organization has set up a password policy, be sure the password meets the requirements. See "About Password Policies".

  7. Under Developer Privileges:

    • User is a developer - To add this user as a developer, select Yes. For end users, select No.

      Developers can create and modify applications and database objects and view developer activity, session state, workspace activity, application, and schema reports.

    • User is a workspace administrator - To add this user as a Workspace administrator, select Yes. For developers or end users, select No.

      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.

      Note:

      You create end users by adding them as users but not defining them as either developers or Workspace administrators, restricting their privileges.

  8. Under Account Control:

    • Account Availability - Select Unlocked to enable a user to log in to this account. Select Unlocked to enable the account to be used.

    • 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 and define password complexity policies. See "Enabling Login Controls for All Workspaces". "About Password Policies", and "Configuring Password Policies"

  9. Click Create User or Create and Create Another.

Editing an Existing User Account

To edit an existing user account:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Workspaces.

  3. Under Manage Workspaces, click Manage Developers and Users.

  4. Locate a user:

    • To narrow the list, select a workspace from the Workspace list and click Go.

    • To locate a specific user, type a user name or partial string in the Find User field and click Go.

    • To view all users, leave the Find User field blank and click Go.

  5. To edit account details, select the user name.

    To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark.

  6. Make the appropriate changes.

  7. Click Apply Changes.

    See Also:

    "Creating New User Accounts"

About the Navigation Bar

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

Description of nav_bar_users_2.gif follows
Description of the illustration nav_bar_users_2.gif

The Manage Developers and Users page navigation bar contains the following controls:

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

  • Workspace. Select a workspace and click Go.

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

Deleting User Accounts

To delete a user account:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Workspaces.

    Under Manage Workspaces, click Manage Developers and Users.

  3. Use the navigation bar at the top of the page to control the display. See "About the Navigation Bar".

    • To narrow the list, select a workspace from the Workspace list and click Go.

    • To locate a specific user, type a user name or partial string in the Find User field and click Go.

    • To view all users, leave the Find User field blank and click Go.

  4. Select a user.

    The Create/Edit User page appears.

  5. Click Delete User.

  6. Confirm your selection and click OK.