Editing Existing User Accounts

Workspace administrators can edit existing user accounts.

To edit an existing user account:

1. Log in to Oracle Application Express. See "Logging In to Oracle Application Express" in Oracle Application Express Application Builder User's Guide.

   The Workspace home page appears.

2. Click the Administration icon.

   The Administration page appears.

3. Click Manage Users and Groups.

   The Users page appears.

4. You can customize the appearance the page using the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

5. Select a user.

   The Edit User page appears.

6. Under Edit User, update the username, email address, first name, last name, and description.

7. Under Account Privileges:

   • Default Schema - Identifies the default schema used for data browsing, application creation, and SQL script execution.

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

   • User is a workspace administrator - Specify if this user should have workspace administrator privileges.

     Administrators are given access to all components. Additionally, they can manage user accounts, groups, and development services. Components may not be available if they are switched off by Instance Administrators.

   • User is a developer - Developers create and modify applications and database objects and view developer activity, session state, workspace activity, application, and schema reports.

   • Application Builder Access - Determines whether a developer has access to the Application Builder.

   • SQL Workshop Access - Determines whether a developer has access to the SQL Workshop.

   • Team Development Access - Determines whether a developer has access to the Team Development.

   • Account Availability - Select Locked to prevent the account from being used. Select Unlocked to enable the account to be used.

     If the user has exceeded the maximum login failures allowed, specified in Workspace Preferences, then there account will be locked automatically.

   
   

   Tip: An Instance administrator can configure these settings for an entire Oracle Application Express instance. See "Configuring Security Settings".

   
   

8. Under Password:

   • Password - Enter a case sensitive password.

   • Confirm Password - Enter the password again.

   • Require Change of Password On First Use - Select No to allow the user to use the same password until it expires. Select Yes to require the user to change the password immediately when logging in the first time.

9. Under User Groups, optionally select one or more user groups by holding down the CTRL key and selecting the groups.

10. Click Apply Changes.