Manage Oracle Application Express Users

You can manage your Oracle Application Express users from Oracle Application Express.

For information on managing Oracle Database Exadata Express Cloud Service users, see Adding Users and Assigning Roles in Getting Started with Oracle Cloud.

About Oracle Application Express User Types

In addition to Oracle Database Exadata Express Cloud Service user roles and privileges, there are Application Express user roles and privileges used to access, develop and administer Application Express applications.

See Adding Users and Assigning Roles in Getting Started with Oracle Cloud for information on Oracle Cloud user roles and privileges.

Application Express has the following types of users:

  • End Users. End users of an Oracle Application Express application managed by the Security page from Infrastructure Console or Application Express authentication. Users that have been granted permission to access an Oracle Application Express application.

  • Developers. Developers of Oracle Application Express applications. Developers have access to the Application Builder and the SQL Workshop.

  • Workspace Administrators. Administrators given access to all Oracle Application Express application components. Additionally, they can manage application user accounts, groups and development services that use Oracle Application Express authorization.

Manage Oracle Application Express Users, Roles and Privileges

Service administrators add and manage users of Oracle Application Express applications from the Oracle Identity Console or Oracle Application Express Administration. During application creation or installation, the method for managing users is defined.

  • Oracle Identity Console (default). Use the Oracle Identity Console to add and manage application users if Oracle Identity Console is the application's authentication method selected during installation or creation. To learn more, see Adding Users and Assigning Roles in Getting Started with Oracle Cloud.
  • Oracle Application Express Administration. Use the Manage Users and Groups page of the Oracle Application Express Administration to add and manage application end users if Oracle Application Express is the application's authentication method selected during installation or creation.

    To manage Oracle Application Express users:

    1. Access Oracle Application Express Application Builder from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

      The Application Builder home page displays.

    2. Click the Administration menu Administration menu at the top right.

      The Administration menu displays.

    3. Select Administration.

      The Administration home page displays.

    4. Click Manage Users and Groups.

      The Manage Users and Groups page appears.

    To learn more, see Managing Users in a Workspace in Oracle Application Express Administration Guide.