2.1 Understanding Workspace Administration

Use Workspace Administration to monitor and administer a workspace.

Note:

Many configuration options are available at both the workspace and instance-level. Instance-level settings generally override similar settings found in Workspace Administration.

• What is a Workspace Administrator?
  Workspace administrators have all the rights and privileges available to developer and manage administrator tasks specific to a workspace.
• Accessing the Workspace Administration Page
  Use the Workspace Administration page to monitor and administer a workspace.
• Workspace Administration Page
  Use the Workspace Administration page to manage service requests, manage users and groups, monitor activity, view dashboards, view the Utilization Report, change your password, manage interactive report settings, manage the Export Repository and Websheet Database objects, and request a new workspace.
• Resetting Your Password
  Reset your password by clicking Change My Password under Tasks on the Workspace Administration page.
• Viewing Product Release and Environment Information
  Access the About Application Express page to view basic product information, including the Application Express release number, workspace name, environment details, and database information.
• Managing Export Files in the Current Workspace
  Use the Manage Export Repository to manage Export files in the current workspace.
• Managing Saved Interactive Reports
  View and delete saved interactive reports as well as manage interactive report subscriptions.
• Viewing a Workspace Summary
  Use the Workspace Utilization report to view a comprehensive summary of the current workspace, including summaries of schemas, database applications, Websheet applications, SQL Workshop scripts and results, Team Development details, application activity, developer activity, and counts of database objects.
• Removing and Validating Websheet Database Objects
  Remove or validate the data objects associated with Websheets.
• Requesting a Workspace in Workspace Administration
  Request a workspace on the Workspace Administration page.

2.1.1 What is a Workspace Administrator?

Workspace administrators have all the rights and privileges available to developer and manage administrator tasks specific to a workspace.

In Oracle Application Express, users sign in to a shared work area called a workspace. A workspace enables multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. This flexible architecture enables a single database instance to manage thousands of applications.

Within a workspace, End users can only run existing database or Websheet application. Developers can create and edit applications, monitor workspace activity, and view dashboards. Oracle Application Express includes two administrator roles:

• Workspace administrators are users who perform administrator tasks specific to a workspace.

• Instance administrators are superusers that manage an entire hosted Oracle Application Express instance which may contain multiple workspaces.

Workspace administrators can reset passwords, view product and environment information, manage the Export Repository, manage saved interactive reports, view the workspace summary report, and manage Websheet database objects. Additionally, workspace administrators manage service requests, configure workspace preferences, manage user accounts, monitor workspace activity, and view log files.

See Also:

"About Application Express User Roles"and "What Is an Instance Administrator?"

2.1.2 Accessing the Workspace Administration Page

Use the Workspace Administration page to monitor and administer a workspace.

Tip:

You can access many workspace administration functions from both the Administration menu and by clicking options on the Workspace Administration home page.

To access the Workspace Administration page:

1. Sign in to Oracle Application Express.

   The Workspace home page appears.

2. At the top of the page, click the Administration menu.
3. From the Administration menu, select Administration.
   
   Description of the illustration admin_menu.png

   The Administration page appears.

See Also:

"Workspace Administration Page"

2.1.3 Workspace Administration Page

Use the Workspace Administration page to manage service requests, manage users and groups, monitor activity, view dashboards, view the Utilization Report, change your password, manage interactive report settings, manage the Export Repository and Websheet Database objects, and request a new workspace.

System Message Region

The System Message region displays at the top of the page. Administrators can use this region to communicate with other users within an instance. See "Defining a System Message."

Description of the illustration wrkspc_admin_pg.png

Workspace Administration Icons

The top of Workspace Administration page also contains the following icons:

• Manage Service. Manage service requests (including, schema requests, storage requests, and service termination) and configure workspace preferences, edit announcements, view utilization reports and log files, and manage session state. See "Manage Service Page."

• Manage Users and Groups. Manage Application Express user accounts and user groups. See "Managing Users in a Workspace."

• Monitor Activity. Monitor page views, developer activity, active sessions, view page view analysis reports, environment reports such as browser usage and click counts, and user login reports. See "Monitoring Activity Within a Workspace."

• Dashboards. View details about the current workspace and monitor users, activity, developer activity, performance, Websheet application development, database application development, and view database details. See "Viewing Workspace Dashboards."

• Utilization Report. View a comprehensive summary of the current workspace, including schemas, database applications, Websheet applications, SQL Workshop scripts and results, Team Development details, application activity, developer activity, and counts of database objects. See "Viewing a Workspace Summary"

Workspace Message

The Workspace Message region displays directly below the icons at the top of the Workspace Administration page. Use this region to communicate information to other users. See "Defining a Workspace Message in Workspace Administration."

Tasks Region

A Tasks region displays on the right side of the Workspace Administration page and contains the following links:

• Change My Password. Links to the Change Password section of the Edit Profile page. See "Resetting Your Password."

• About Application Express. Links to an About page that lists basic product information. See "Viewing Product Release and Environment Information."

• Manage User Groups. Links to the User groups page. Workspace administrators can use groups for categorization and to manage privileges. See "Using Groups to Manage Application Express Users."

• Create User. Links to a form where Workspace administrators can create new user. See "Creating User Accounts."

• Create Multiple Users. Enables Workspace administrators to create multiple users once. See "Creating Multiple Users Simultaneously."

• Delete Multiple Users. Enables Workspace administrators to delete multiple users at once. See "Deleting Multiple Users at Once."

• Manage Interactive Report Settings. Enables Workspace administrators to manage saved reports and subscriptions. See "Managing Saved Interactive Reports."

• Manage Export Repository. Displays to the Manage Export Repository. Use the Manage Export Repository page to manage files in the current workspace. See "Managing Export Files in the Current Workspace."

• Websheet Database Objects. Use the Websheet Database Objects page to remove or validate the data objects associated with Websheets. See "Removing and Validating Websheet Database Objects."

• Request a New Workspace. Enables Workspace administrators to request a new workspace manually using the Request a Workspace wizard. See "Requesting a Workspace in Workspace Administration."

2.1.4 Resetting Your Password

Reset your password by clicking Change My Password under Tasks on the Workspace Administration page.

Note:

To ensure the security and performance of your development environment, this functionality is not available in Application Express instances running in Oracle Cloud.

To reset your password from the Administration page:

Tip:

You can access many workspace administration functions (such as Change My Password) from both the Administration menu and the Workspace Administration home page. For consistency, this section navigates the user to the Workspace Administration home page.

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Tasks list, click Change My Password.
3. Under Change Password, enter the following:

   • Enter Current Password - Enter your current password.

   • Enter New Password - Enter your new password.

   • Confirm New Password - Enter your new password again.

4. Click Apply Changes.

See Also:

"Changing a User Account Password"

2.1.5 Viewing Product Release and Environment Information

Access the About Application Express page to view basic product information, including the Application Express release number, workspace name, environment details, and database information.

To view the About Application Express page:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Tasks list, click About Application Express.

   The About Application Express page appears. The page is divided into these sections: About; Visit Oracle Online For More Information; CGI Environment; and Database Version.

The Details section displays the following information:

• Product build

• Schema compatibility

• Last DDL time

• Host schema

• Application Owner

• Workspace ID

• Workspace Name

• Current user

• Language Preference

• Current Time (on server)

CGI Environment provides information about the currently installed web server software such as currently defined parameters and variables.

Database Version lists details about the currently installed database version.

Character Set lists currently selected character sets. The selected character set determines the encoding scheme used to display characters on screen.

2.1.6 Managing Export Files in the Current Workspace

Use the Manage Export Repository to manage Export files in the current workspace.

Use the Manage Export Repository page in Workspace Administration to download or delete Export files.

To access the Manage Export Repository page:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Tasks list, click Manage Export Repository.
3. To download a file, click the file name in the Download column..
4. To delete a file, select the file and click Delete Checked.

See Also:

• "Exporting and Importing a Workspace"

• "Exporting an Application and Application Components," "Importing Export Files," and "Installing Export Files" in Oracle Application Express App Builder User’s Guide

2.1.7 Managing Saved Interactive Reports

View and delete saved interactive reports as well as manage interactive report subscriptions.

• About Saved Interactive Reports
  Oracle Application Express includes four types of saved interactive reports: Primary Default, Alternative Report, Public Report, and Private report. Both developers and end users can save interactive reports. However, only a developer can save the report that initially displays (called the Primary Default) or create an Alternative report.
• Viewing and Deleting Saved Interactive Reports
  View and delete saved interactive reports on the Saved Reports page.
• Managing Interactive Report Subscriptions
  End users can receive updated versions of a report by subscribing to it. Workspace administrators can view and manage these subscriptions on the Subscriptions page.

See Also:

"Developing Reports" in Oracle Application Express App Builder User’s Guide

2.1.7.1 About Saved Interactive Reports

Oracle Application Express includes four types of saved interactive reports: Primary Default, Alternative Report, Public Report, and Private report. Both developers and end users can save interactive reports. However, only a developer can save the report that initially displays (called the Primary Default) or create an Alternative report.

Oracle Application Express includes four types of saved interactive reports:

• Primary Default (Developer Only). This is the report that initially displays. Primary Default reports cannot be renamed or deleted.

• Alternative Report (Developer Only). Enables developers to create multiple report layouts. Only developers can save, rename, or delete an Alternative Report.

• Public Report (End user). Can be saved, renamed, or deleted by the end user who created it. Other users can view and save the layout as another report.

• Private Report (End user). Only the end user that created the report can view, save, rename, or delete the report.

Workspace administrators can view and manage these reports on the Saved Reports page.

2.1.7.2 Viewing and Deleting Saved Interactive Reports

View and delete saved interactive reports on the Saved Reports page.

To manage saved interactive reports:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. From the Tasks list, click Manage Interactive Report Settings.
3. Click Saved Reports.

   The Saved Reports page appears.

   You can customize the appearance of the page using the Search bar at the top of the page.

4. To delete a report:
   1. Select the report to be removed.
   2. Click Delete Checked.

2.1.7.3 Managing Interactive Report Subscriptions

End users can receive updated versions of a report by subscribing to it. Workspace administrators can view and manage these subscriptions on the Subscriptions page.

To manage interactive report subscriptions:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. From the Tasks list, click Manage Interactive Report Settings.
3. Click Subscriptions.

   The Subscriptions page appears.

   You can customize the appearance of the page using the Search bar at the top of the page.

4. To link to an application, page or region, click the appropriate hyperlink.
5. To delete a subscription:
   1. Select the subscription to be removed.
   2. Click Delete Checked.

2.1.8 Viewing a Workspace Summary

Use the Workspace Utilization report to view a comprehensive summary of the current workspace, including summaries of schemas, database applications, Websheet applications, SQL Workshop scripts and results, Team Development details, application activity, developer activity, and counts of database objects.

Note:

To ensure the security and performance of your development environment, this functionality is not available in Application Express instances running in Oracle Cloud.

• Viewing the Workspace Utilization Report
  View the Workspace Utilization Report which details workspace activity and contents.
• Emailing the Workspace Utilization Report
  Email specific recipients a workspace summary report by clicking the Email button while viewing the Workspace Utilization Report.

2.1.8.1 Viewing the Workspace Utilization Report

View the Workspace Utilization Report which details workspace activity and contents.

To view the Workspace Utilization report:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Workspace Administration page, click Manage Service.
3. Click Workspace Utilization.
4. From Show, select a time interval.
5. Scroll down to view the report.

2.1.8.2 Emailing the Workspace Utilization Report

Email specific recipients a workspace summary report by clicking the Email button while viewing the Workspace Utilization Report.

To email the Workspace Utilization report:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Workspace Administration page, click Manage Service.
3. Click Workspace Utilization.
4. From Show, select a time interval.
5. To email the report:
   1. Click Email.
   2. In the Email form:

      • Reporting Periods - Select a time interval for the report.

      • To - Enter valid email addresses. Separate multiple entries with a comma.

      • Subject - Enter text that describes the message.

      • Body - Enter optional body text.

      • Click Email.

      The report is automatically emailed to the specified recipients.

2.1.9 Removing and Validating Websheet Database Objects

Remove or validate the data objects associated with Websheets.

All Websheet application data is stored within tables owned by a schema associated with this workspace. The tables are all prefixed by APEX$_. Workspace administrators use the Websheet Database Objects page to manage these tables.

To access the Websheet Database Objects page:

1. Navigate to the Workspace Administration page:
   1. Sign in to Oracle Application Express.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.

   The Workspace Administration home page appears.

2. On the Tasks list, click Manage Websheet Database Objects.

   The Websheet Database Objects page appears.

3. Select one of the following and follow the on-screen instructions:

   • Remove Websheet Database Objects - Drop Websheet database objects and data from your schema.

   • Validate Websheet Database Objects - Validate the integrity of Websheet database objects and correct identified problems.

See Also:

"Creating Websheet Applications" in Oracle Application Express App Builder User’s Guide

2.1.10 Requesting a Workspace in Workspace Administration

Request a workspace on the Workspace Administration page.

Note:

To ensure the security and performance of your development environment, this functionality is not available in Application Express instances running in Oracle Cloud.

Note:

The Request a New Workspace option described in this topic only works if the workspace Provisioning Method is set to Request or Automatic. If the workspace Provisioning Method is set to Manual, an error displays. See "Selecting a Workspace Provisioning Mode".

To request a new workspace in the Workspace Administration:

1. Sign in to Oracle Application Express.
2. At the top of the Workspace home page, click the Administration menu and select Administration
   The Workspace Administration home page appears.
3. From Tasks on the right side of the page, click Request a New Workspace.
   The Request a Workspace Wizard appears.
4. For Identification:
   1. First Name - Enter your first name.
   2. Last Name - Enter your last name.
   3. Email - Enter the email address. A validation link will be sent to this email address.
   4. Workspace - Enter a workspace name that name uniquely identifies your development environment.
   5. Click Next.
5. Verify your request and click Submit Request.
   Once you complete the Identification form, the following events occur:

   1. You will receive an email containing a verification link.

   2. When you click the verification link, the workspace is created.

   3. You will receive another email containing Sign In credentials (that is, the workspace name, username, and password).

   4. The status of the workspace request changes from Accepted to Approved.

See Also:

• "Requesting Another Workspace"

• "About the Workspace Request Approval Process"

• "Creating Workspaces in Administration Services"

• "Requesting a Workspace from the Sign In Dialog" in Oracle Application Express Installation Guide