Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 20.1 for Oracle Application Express Administration Guide
-
2
Workspace and Application Administration
-
2.1
Understanding Workspace Administration
- 2.1.1 What is a Workspace Administrator?
- 2.1.2 Accessing the Workspace Administration Page
- 2.1.3 Workspace Administration Page
- 2.1.4 Resetting Your Password
- 2.1.5 Viewing Product Release and Environment Information
- 2.1.6 Managing Export Files in the Current Workspace
- 2.1.7 Managing Saved Interactive Reports
- 2.1.8 Viewing a Workspace Summary
- 2.1.9 Removing and Validating Websheet Database Objects
- 2.1.10 Requesting a Workspace in Workspace Administration
- 2.2 Monitoring Activity Within a Workspace
- 2.3 Using the Manage Service Page
- 2.4 Making a Service Request
-
2.5
Configuring Workspace Preferences
- 2.5.1 Managing Workspace Account Login Controls
- 2.5.2 Controlling Access to App Builder
- 2.5.3 Controlling Access to SQL Workshop
- 2.5.4 Disabling PL/SQL Program Unit Editing for a Workspace
- 2.5.5 Enabling RESTful Services and Defining a Path Prefix for a Workspace
- 2.5.6 Configuring Team Development in an Existing Workspace
- 2.5.7 Configuring Session Timeout for a Workspace
- 2.6 Defining a Workspace Message in Workspace Administration
-
2.7
Managing Users in a Workspace
- 2.7.1 About Application Accounts Authentication
- 2.7.2 About Application Express User Roles
- 2.7.3 Creating User Accounts
- 2.7.4 Editing Existing User Accounts
- 2.7.5 Locking and Unlocking a User Account
- 2.7.6 Changing a User Account Password
- 2.7.7 Deleting User Accounts
- 2.7.8 Viewing the Users Dashboard
- 2.7.9 Using Groups to Manage Application Express Users
- 2.8 Accessing the Data Dictionary Cache Report from Workspace Administration
- 2.9 Purging the Developer Activity and Click Count Log Files
- 2.10 Managing Session State for a Workspace
-
2.11
Managing User Preferences
- 2.11.1 Setting User Preferences
- 2.11.2 Viewing Preferences by User
- 2.11.3 Viewing Current User Preferences
- 2.11.4 Purging Preferences for a Specific User
- 2.11.5 Purging Preferences for the Current User
- 2.11.6 Removing User Preferences Programmatically
- 2.11.7 Resetting User Preferences Using a Page Process
- 2.12 Managing Page and Region Caching
- 2.13 Changing Build Status for Multiple Applications
- 2.14 Viewing Workspace Dashboards
- 2.15 Leveraging App Builder Defaults
-
2.1
Understanding Workspace Administration
-
3
Oracle Application Express Administration Services
- 3.1 What Is an Instance Administrator?
- 3.2 Signing In To Administration Services
- 3.3 Overview: Administration Services UI
- 3.4 Managing Requests
-
3.5
Managing Instance Settings
-
3.5.1
Managing Feature Configuration
-
3.5.1.1
Configuring Application Development
Settings
- 3.5.1.1.1 Disabling PL/SQL Program Unit Editing for an Instance
- 3.5.1.1.2 Enabling the Creation of Demonstration Objects in New Workspaces
- 3.5.1.1.3 Enabling the Creation of Websheet Objects in New Workspaces
- 3.5.1.1.4 Enabling and Disabling SQL Access in Websheets
- 3.5.1.1.5 Configuring the Number of Application Backups
- 3.5.1.2 Configuring Application Installation Options
- 3.5.1.3 Configuring SQL Workshop
- 3.5.1.4 Configuring Monitoring
- 3.5.1.5 Enabling RESTful Services for an Instance
- 3.5.1.6 Enabling Service Requests
- 3.5.1.7 Configuring Team Development for New Workspaces
-
3.5.1.1
Configuring Application Development
Settings
-
3.5.2
Configuring Security
-
3.5.2.1
Configuring Service-level Security Settings
- 3.5.2.1.1 Controlling If Cookies Populate the Login Form
- 3.5.2.1.2 Disabling Access to Oracle Application Express Administration Services
- 3.5.2.1.3 Enabling Access to Oracle Application Express Administration Services
- 3.5.2.1.4 Disabling Workspace Login Access
- 3.5.2.1.5 Controlling Public File Upload
- 3.5.2.1.6 Restricting User Access by IP Address
- 3.5.2.1.7 Configuring a Proxy Server for an Instance
- 3.5.2.1.8 Selecting a Checksum Hash Function
- 3.5.2.1.9 Configuring Rejoin Sessions for an Instance
- 3.5.2.1.10 Configuring Unhandled Errors
- 3.5.2.2 Configuring HTTP Protocol Attributes
- 3.5.2.3 Enabling Real Application Security
- 3.5.2.4 Configuring Session Timeout for an Instance
- 3.5.2.5 Isolating All Workspaces in an Instance
- 3.5.2.6 Defining Excluded Domains for Regions and Web Services
- 3.5.2.7 Configuring Authentication Controls for an Instance
- 3.5.2.8 Creating Strong Password Policies
- 3.5.2.9 Restricting Access to Oracle Application Express by Database Access Descriptor (DAD)
- 3.5.2.10 Managing Authorized URLs
-
3.5.2.1
Configuring Service-level Security Settings
-
3.5.3
Configuring Instance Settings
- 3.5.3.1 About Configuring Workspace Provisioning
- 3.5.3.2 Disabling Email Provisioning
- 3.5.3.3 Configuring Storage
- 3.5.3.4 Configuring Email
- 3.5.3.5 Configuring Wallet Information
- 3.5.3.6 Configuring Report Printing
- 3.5.3.7 Configuring the Help Menu
- 3.5.3.8 Configuring Workspace Size Requests
- 3.5.3.9 Managing Application ID Range
- 3.5.4 Purging Inactive Workspaces
- 3.5.5 Using the REST Administration Interface to View Usage Statistics
-
3.5.1
Managing Feature Configuration
- 3.6 Using the Productivity and Sample Applications Repository
- 3.7 Managing Public Themes
- 3.8 Managing Meta Data
- 3.9 Installing Exported Applications in a Runtime Environment
- 3.10 Communicating with Users Using Messages and Task Lists
-
3.11
Managing Logs and Files
- 3.11.1 Deleting SQL Workshop Logs
- 3.11.2 Deleting Page View Activity Log Entries
- 3.11.3 Deleting Developer Activity Log Entries
- 3.11.4 Managing Developer Log Retention
- 3.11.5 Deleting Click Counting Log Entries
- 3.11.6 Deleting Web Service Log Entries
- 3.11.7 Deleting the Login Access Log
- 3.11.8 Managing Log Intervals
- 3.11.9 Archiving the Activity Log
- 3.12 Creating a Service Signup Wizard
-
3.13
Managing Schemas
- 3.13.1 What Is the Oracle Application Express Engine Schema?
- 3.13.2 Determining the Oracle Application Express Engine Schema
- 3.13.3 Understanding Oracle Default Schema Restrictions
- 3.14 Creating Workspaces in Administration Services
-
3.15
Managing Existing Workspaces
- 3.15.1 Viewing Existing Workspace Information
- 3.15.2 Viewing the Application Attributes Report
- 3.15.3 Deleting a Workspace
- 3.15.4 Locking a Workspace
-
3.15.5
Managing Workspace to Schema Assignments
- 3.15.5.1 Viewing Schema and Workspace Assignments in a Development Environment
- 3.15.5.2 Viewing Schema and Workspace Assignments in a Runtime Environment
- 3.15.5.3 Editing Existing Schema and Workspace Assignments
- 3.15.5.4 Associating Schemas in a Full Development Environment
- 3.15.5.5 Associating Additional Schemas in a Runtime Environment
- 3.15.5.6 Removing a Schema Mapping from a Workspace in a Runtime Environment
- 3.15.6 Managing Component Availability for an Instance
- 3.15.7 Performing a Workspace Search
- 3.15.8 Isolating a Workspace to Prevent Browser Attacks
- 3.15.9 Viewing the Workspace Details Report
- 3.15.10 Viewing Workspace Database Privileges
- 3.15.11 Viewing File Size and File Count by Workspace
- 3.15.12 Finding and Emailing Workspace Summary
- 3.15.13 Accessing the Data Dictionary Cache Report from Administration Services
- 3.15.14 Exporting and Importing a Workspace
- 3.15.15 Exporting Workspaces, Apps, and Related Files from a Command-line
- 3.15.16 Changing Application Build Status in Administration Services
- 3.15.17 Viewing the Parsing Schemas Report
-
3.16
Managing Users Across an Application Express Instance
- 3.16.1 About the Advantages of Managing Users at the Instance Level
- 3.16.2 About Application Accounts Authentication
- 3.16.3 About Application Express User Roles
- 3.16.4 Creating New User Accounts in Administration Services
- 3.16.5 Editing an Existing User Account in Administration Services
- 3.16.6 Deleting User Accounts in Administration Services
- 3.17 Monitoring Activity Across a Development Instance
- A DBMS_SCHEDULER Jobs
- Index