About Oracle Application Express User Roles

When setting up Application Express users at a large organization, you assign roles and privileges to specific users. The roles within Oracle Application Express include the following:

• Workspace administrators are users who perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files. For this guide, you are acting as the workspace administrator when setting up the development environment.

• Developers are users who create and edit applications and modify database objects. Developers can have their own workspace or share a workspace.

• End users have no development privileges. You define end users so that they can access applications that do not use an external authentication scheme.

• Instance administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application.

The following illustration shows multiple users with various roles accessing the Oracle Application Express development environment, Application Express Administration Services, and the published applications.

Description of the illustration arch_diffroles2.gif

For this guide, you must have the privileges usually associated with three roles: Application Express Administrator, Workspace Administrator, and Developer. The following illustration shows an Oracle Application Express instance with a single user.

Description of the illustration arch2_single.gif