What Is an Oracle Application Express Administrator?

Oracle Application Express administrators are responsible for managing an entire Oracle Application Express instance.

In the Oracle Application Express, users log in to a shared work area called a workspace. These users are divided into three primary roles:

Developers create and edit applications.
Workspace administrators are developers who also perform administrator tasks specific to their workspace such as managing user accounts, monitoring workspace activity, and viewing log files. See "Workspace and Application Administration".
Oracle Application Express administrators are superusers that manage the entire hosted instance using the Oracle Application Express Administration Services application.

See Also:

Refer to the appropriate installation guide for your platform for information about installing Oracle Application Express

About the Manage Service Page

Oracle Application Express administrators use the Manage Service page to configure service for an Oracle Application Express instance.

In the Manage Service section:

Site-Specific Tasks. See "Creating a Site-Specific Tasks List".
Logs. See "Managing Log Entries".
Session State. See "Managing Session State".
Mail Queue. See "Managing Mail".
Installed Translations. See "Viewing Installed Translations".

In the Manage Environment Settings section:

Feature Configuration:
- Application Development. See "Disabling PL/SQL Program Unit Editing for an Instance" and "Disabling the Creation of Demonstration Applications in a New Workspace".
- SQL Workshop. See "Configuring SQL Workshop".
- Monitoring. See "Enabling Database Monitoring".
Security. See "Configuring Security Settings".
Instance Settings:
- Self Service. See "Specifying a Provisioning Mode".
- Email. See "Configuring Email Settings".
- Wallet. See "Configuring Wallet Information".
- Report Printing. See "Configuring Report Printing".
- New Workspace Request Size. See "Configuring Workspace Size Options for Requests".
Messages. See "Managing Login and System Messages"

See Also:

"Managing Existing Workspaces" and "About the Manage Workspaces Page"

About the Manage Workspaces Page

Oracle Application Express administrators use the Manage Workspaces page to manage workspaces for an Oracle Application Express instance.

In the Manage Requests section:

Workspace Requests. See "Managing Workspace Requests"
Change Requests. See "Managing Change Requests".

In the Manage Workspaces section:

Create Workspace. See "Creating Workspaces".
Remove Workspace. See "Removing a Workspace".
Lock Workspace. See "Locking a Workspace".
Manage Workspace to Schema Assignments. See "Managing Workspace to Schema Assignments".
Manage Developers and Users. See "Managing Users in an Oracle Application Express Instance".
Import Workspace. See "Exporting and Importing a Workspace".
Export Workspace. See "Exporting and Importing a Workspace".

In the Workspace Reports section:

Existing Workspaces. See "Viewing Existing Workspaces".
Workspace Details. See "Viewing Workspace Details".
Workspace Database Privileges. See "Viewing Workspace Database Privileges".

See Also:

"Managing Existing Workspaces"