WIXLIB

3.4.1.1Controlling Workspace Cookies3-293.4.1.2Controlling Persistent Authentication3-293.4.1.3Disabling Access to Administration Services3-303.4.1.4Enabling Access to Oracle APEX Administration Services3-313.4.1.5Disabling Workspace Login Access3-313.4.1.6Controlling Public File Upload3-323.4.1.7Restricting User Access by IP Address3-323.4.1.8Configuring a Proxy Server for an Instance3-333.4.1.9Selecting a Checksum Hash Function3-333.4.1.10Configuring Rejoin Sessions for an Instance3-343.4.1.11Configuring Unhandled Errors3-35Configuring HTTP Protocol Attributes3-363.4.23.4.2.1About SSL3-363.4.2.2Requiring HTTPS3-373.4.2.3Reversing Require HTTPS3-373.4.2.4Reversing Require Outbound HTTPS3-383.4.2.5Configuring Additional Response Headers3-393.4.3Enabling Real Application Security3-393.4.4Configuring Session Timeout for an Instance3-403.4.5Isolating All Workspaces in an Instance3-413.4.5.1About Isolating Workspaces to Prevent Browser Attacks3-413.4.5.2Configuring Instance-Level Workspace Isolation Attributes3-423.4.6Defining Excluded Domains for Regions and Web Services3-443.4.7Configuring Authentication Controls for an Instance3-453.4.7.1About Authentication Controls3-453.4.7.2Configuring Security for Developer and End User Login3-463.4.7.3Configuring Authentication Schemes for an Instance3-463.4.7.4Configuring Security Settings for Workspace Administrator andDeveloper Accounts3-583.4.83-593.4.8.1About Strong Password Policies3-593.4.8.2Configuring Password Policies3-593.4.93.5Creating Strong Password PoliciesManaging Authorized URLs3-613.4.9.1Defining a List of Authorized URLs3-613.4.9.2Editing a Defined Authorized URL3-623.4.9.3Deleting Defined Authorized URL3-62Configuring Instance Settings3-623.5.1About Configuring Workspace Provisioning3-643.5.2Disabling Email Provisioning3-643.5.3Configuring Storage3-653.5.3.1Requiring a New Schema3-65vii

3.5.3.2Enabling Auto Extend Tablespaces3-663.5.3.3Enabling Bigfile Tablespaces3-663.5.3.4Enabling Encrypted Tablespaces3-673.5.3.5Enabling Automatic Approval of Storage Requests3-673.5.3.6Deleting Uploaded Files3-683.5.4About Enabling Network Services3-693.5.4.2Configuring Email in a Full Development Environment3-703.5.4.3Configuring Email in a Runtime Environment3-713.5.4.4Determining Email Settings in a Runtime Environment3-72Configuring Wallet Information3-723.5.5.1About SSL and Wallet Creation3-733.5.5.2Configuring a Wallet in a Full Development Environment3-733.5.5.3Configuring a Wallet in a Runtime Environment3-743.5.5.4Determining Wallet Settings in a Runtime Environment3-753.5.6Configuring Report Printing for an Instance3-753.5.6.1About Configuring Report Printing3-753.5.6.2Configuring Report Printing in a Full Development Environment3-763.5.6.3Configuring Report Printing Settings in a Runtime Environment3-773.5.6.4Determining Report Printing Settings in a Runtime Environment3-783.5.7Configuring Workflow Settings3-793.5.8Configuring the Application Gallery3-793.5.8.1About the Application Gallery3-803.5.8.2Special Use Cases3-803.5.93.73-693.5.4.13.5.53.6Configuring EmailConfiguring the Help Menu3-843.5.10Configuring Workspace Size Requests3-843.5.11Managing Application ID Range3-853.5.12Configuring Background Jobs3-85Managing Public Themes3-863.6.1Adding a Public Theme to the Theme Repository3-863.6.2Deleting a Public Theme3-873.6.3Modifying a Public Theme3-873.6.4About Exporting a Public Theme3-88Managing Meta Data3.7.13-88Managing Session State for an Instance3-883.7.1.1About Session State3-893.7.1.2Viewing Session Details Before Purging3-893.7.1.3Purging Sessions by Age3-903.7.1.4Viewing Session Statistics Before Purging3-903.7.2Managing the Mail Queue3.7.2.13-90Sending and Deleting Messages in the Mail Queue3-91viii

3.7.3Viewing Installed Translations3-913.7.4Deleting Interactive Report Subscriptions3-923.8Communicating Using Messages, Banners, and Resources List3.8.1Defining a Login Message3-923-933.8.1.1About Login Messages3-933.8.1.2Creating or Editing the Login Message3-943.8.2Defining a System Message3-953.8.2.1About System Messages3-953.8.2.2Creating and Editing a System Message3-953.8.3Defining a Workspace Message in Administration Services3-963.8.4Configuring an Environment Banner in Administration Services3-963.8.5Managing a Site-Specific Resources List3-983.93.8.5.1Adding a New Task3-993.8.5.2Editing an Existing Task3-993.8.5.3Deleting a TaskCreating a Service Signup Wizard3-1003-1003.9.1Defining a Service Signup Wizard3-1003.9.2Running a New Service Signup Wizard3-1013.10Managing Schemas3-1023.10.1What Is the Oracle APEX Engine Schema?3-1023.10.2Determining the Oracle APEX Engine Schema3-1033.10.3Understanding Oracle Default Schema Restrictions3-1033.113.10.3.1About Assigning Oracle Default Schemas to Workspaces3-1043.10.3.2Granting the Privilege to Assign Oracle Default Schemas3-1043.10.3.3Revoking the Privilege to Assign Oracle Default Schemas3-1053.10.3.4Working with Restricted Schemas3-1053.10.3.5Determining the Privilege Status3-106Creating Workspaces in Administration Services3-1073.11.1About Workspaces3-1083.11.2About Specifying How Workspaces Are Created3-1083.11.3Selecting a Workspace Provisioning Mode3-1093.11.4How Oracle-Managed Files Affects Workspace Provisioning3-1103.11.5Creating a Workspace Manually3-1113.11.5.1Creating Workspace Manually in a Full Development Environment3-1113.11.5.2Creating a Workspace Manually in a Runtime Environment3-1123.11.63.12Creating Multiple WorkspacesManaging Existing Workspaces3-1133-1143.12.1Performing a Workspace Search3-1163.12.2Editing Workspace Information3-1163.12.3Isolating a Workspace to Prevent Browser Attacks3-1193.12.3.1About Isolating a Workspace to Prevent Browser Attacks3-119ix

3.12.3.23.12.4Configuring Workspace Isolation Attributes3-120Deleting a Workspace3-1233.12.4.1Identifying and Deleting Inactive Workspaces3-1233.12.4.2Deleting Workspaces in a Full Development Environment3-1253.12.4.3Deleting Workspaces in a Runtime Development Environment3-1263.12.5Locking a Workspace3-1263.12.6Purging Inactive Workspaces3-1273.12.6.13.12.7Configuring Workspace Purge Settings3-127Managing Workspace to Schema Assignments3.12.7.13-128Viewing Schema and Workspace Assignments in a DevelopmentEnvironment3-129Viewing Schema and Workspace Assignments in a RuntimeEnvironment3-1293.12.7.3Editing Existing Schema and Workspace Assignments3-1303.12.7.4Associating Schemas in a Full Development Environment3-1303.12.7.5Associating Additional Schemas in a Runtime Environment3-1313.12.7.6Removing a Schema Mapping from a Workspace in a RuntimeEnvironment3-1313.12.7.23.12.8Managing Component Availability for an Instance3-1323.12.9Exporting and Importing a Workspace3-1333.12.9.1About Exporting and Importing a Workspace3-1333.12.9.2Exporting a Workspace in Administration Services3-1343.12.9.3Importing a Workspace in Administration Services3-134Installing Exported Applications in a Runtime Environment3-1353.12.103.12.10.1About the Advantages of Using Runtime Environment3-1353.12.10.2Installing an Exported Application in to a Runtime Environment3-1363.12.11Exporting and Importing from a Command Line3-1363.12.11.1Exporting and Importing Using SQLcl3-1373.12.11.2Exporting Using the APEXExport Utility (Deprecated)3-1543.12.12Changing Application Build Status in Administration Services3-1573.12.12.1About Changing Application Build Status3-1583.12.12.2Changing Build Status in Administration Services3-1583.12.13Viewing the Application Attributes Report3-1593.12.14Accessing Workspace Reports3-1593.12.14.1Viewing the Workspace Details Report3-1603.12.14.2Viewing Workspace Database Privileges3-1613.12.14.3Viewing File Size and File Count by Workspace3-1613.12.14.4Finding and Emailing Workspace Summary3-1623.12.14.5Accessing the Data Dictionary Cache Report from AdministrationServices3-1623.12.153.13Viewing the Parsing Schemas Report3-163Managing Users Across an Oracle APEX Instance3-164x

3.13.1About the Advantages of Managing Users at the Instance Level3-1643.13.2About Oracle APEX Accounts Authentication3-1653.13.3About Oracle APEX User Roles3-1653.13.4Creating New User Accounts in Administration Services3-1653.13.5Editing an Existing User Account in Administration Services3-1673.13.6Deleting User Accounts in Administration Services3-1673.143-1683.14.1About Web Server Logs3-1683.14.2Accessing the Monitor Activity Page in Administration Services3-1693.14.3Viewing the Signup Survey Report3-1703.14.4Viewing the Backup Log3-1713.15AMonitoring Activity Across an InstanceConfiguring and Deleting Logs and Log Entries3-1713.15.1Deleting SQL Workshop Logs3-1723.15.2Deleting Page View Activity Log Entries3-1733.15.2.1About Page View Activity Logs3-1733.15.2.2Truncating Page View Activity Logs Manually3-1733.15.3Deleting Developer Activity Log Entries3-1743.15.4Managing Developer Log Retention3-1743.15.5Deleting Click Counting Log Entries3-1753.15.6Deleting the Login Access Log3-1753.15.7Managing Log Intervals3-1763.15.8Archiving the Activity Log3-1763.15.9Deleting Web Service Log Entries3-1763.15.10Configuring or Deleting the REST Source Synchronization Log3-1773.15.11Configuring or Deleting the Automation Log3-177DBMS SCHEDULER JobsA.1List of DBMS SCHEDULER JobsA-1Indexxi

PrefacePrefaceOracle APEX is a hosted declarative development environment for developing anddeploying database-centric web applications. APEX turns a single Oracle databaseinto a shared service by enabling multiple workgroups to build and access applicationsas if they were running in separate databases.Oracle APEX Administration Guide describes how to perform administration tasks foran Oracle APEX workspace, application, or an entire development instance. Audience Documentation Accessibility Diversity and Inclusion Related Documents ConventionsAudienceOracle APEX Administration Guide describes how to perform administration tasks foran Oracle APEX workspace, application, or an entire development instance.To use this guide, you must have a general understanding of relational databaseconcepts and an understanding of the operating system environment under which youare running Oracle APEX.See Also:Oracle APEX Installation GuideDocumentation AccessibilityFor information about Oracle's commitment to accessibility, visit the OracleAccessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trsif you are hearing impaired.xii

PrefaceDiversity and InclusionOracle is fully committed to diversity and inclusion. Oracle respects and values having adiverse workforce that increases thought leadership and innovation. As part of our initiative tobuild a more inclusive culture that positively impacts our employees, customers, andpartners, we are working to remove insensitive terms from our products and documentation.We are also mindful of the necessity to maintain compatibility with our customers' existingtechnologies and the need to ensure continuity of service as Oracle's offerings and industrystandards evolve. Because of these technical constraints, our effort to remove insensitiveterms is ongoing and will take time and external cooperation.Related DocumentsFor more information, see these Oracle resources: Oracle APEX Release Notes Oracle APEX Installation Guide Oracle APEX End User’s Guide Oracle APEX App Builder User’s Guide Oracle APEX SQL Workshop Guide Oracle APEX API Reference Oracle Database ConceptsConventionsThe following text conventions are used in this document:ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associated with anaction, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables for whichyou supply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, code inexamples, text that appears on the screen, or text that you enter.xiii

1Changes in Release 22.1 for Oracle APEXAdministration GuideAll content in Oracle APEX Administration Guide has been updated to reflect release 22.1functionality.New Features and UpdatesThe following features are new in Oracle APEX: Enable customers to get back into action faster with the new persistent authentication.Sign in once, stay signed in.See Controlling Persistent Authentication. Support of Oracle SQL Developer Command Line (SQLcl)Export workspaces, applications, and related files from a command line using OracleSQL Developer Command Line (SQLcl) release 22.1 and later.See Exporting and Importing Using SQLcl. Workflow SettingsUse the Retention Period in Days attribute to specify the number of days human taskscreated by Approvals are retained before being purged.See Configuring Workflow Settings. Application Gallery SettingsConfigure the location used as the installation source for Application Gallery.See Configuring the Application Gallery. Instance Administration Home Page ChangesThe following new popup LOVs display under Instance Tasks on the AdministrationServices home page: Jump to app and Jump to user.See Administration Services Home Page.Deprecated and Desupported FeaturesSee Deprecated Features and Desupported Features in Oracle APEX Release Notes.1-1

2Workspace and Application AdministrationIn an Oracle APEX development environment, users sign in to a shared work area called aworkspace. Workspace administrators monitor and administer a shared work area called aworkspace. Understanding Workspace AdministrationUse Workspace Administration to monitor and administer a workspace. Using the Manage Service PageUse the Manage Service page to manage service requests, configure workspacepreferences, edit workspace messages, and view reports. Additionally, administrators usethis page to clear log files, manage session state, clear cached content, and manageinteractive report settings. Making a Service RequestWorkspace administrators use the Request Service page to request a schema, addstorage space, terminate a workspace, or request another workspace. Configuring Workspace PreferencesConfigure workspace preferences for workspace login controls, access to App Builderand SQL Workshop, support for PL/SQL editing and RESTful services, and access toTeam Development. Defining a Workspace MessageWorkspace administrators can quickly communicate with other users by creatingworkspace messages. Configuring an Environment Banner for a WorkspaceConfigure a environment banner for a workspace on the Workspace Administration page. Managing Users in a WorkspaceCreate new user accounts, manage existing user accounts, and change user passwords. Accessing the Data Dictionary Cache Report from Workspace AdministrationAccess the Data Dictionary Cache report from Workspace Administration to viewstatistics and data analysis of schema tables and caches in a workspace. Purging the Developer Activity and Click Count Log FilesManually purge developer logs and the External Count Clicks log on the Log files page.Log entries older than one month are automatically deleted. Managing Session State for a WorkspaceA session establishes persistence (or stateful behavior) across page views. Workspaceadministrators can view session details for the current session or for recent sessions,purge the current session state, or purge sessions based on their age. Managing User PreferencesDevelopers can use preferences to store values for a specific Oracle APEX user acrossdistinct sessions. Once set, these preferences can be removed programmatically ormanually. Administrators can set user preferences by creating a page process, by thecalculation of a preference Item Source Value, or programmatically by using a PL/SQLAPI.2-1

Chapter 2Understanding Workspace Administration Managing Page and Region CachingImprove an application's performance by taking advantage of page and regioncaching. Changing Build Status for Multiple ApplicationsConfigure the Build Status attribute at the workspace-level to prevent anapplication from being modified by other developers. Leveraging App Builder DefaultsApp Builder Defaults enable developers to reduce the number of steps needed tocreate a new application. Monitoring Activity Within a WorkspaceMonitor developer activity and changes within a workspace by accessing theMonitor Activity page. Viewing Workspace DashboardsUse the Dashboard page to view details about the current workspace and monitoroverall workspace activity.See Also: Oracle APEX Administration Services Understanding Developer Security Best Practices in Oracle APEX AppBuilder User’s Guide2.1 Understanding Workspace AdministrationUse Workspace Administration to monitor and administer a workspace.Note:Many configuration options are available at both the workspace andinstance-level. Instance-level settings generally override similar settingsfound in Workspace Administration. What is a Workspace Administrator?Workspace administrators have all the rights and privileges available to developerand manage administrator tasks specific to a workspace. Accessing the Workspace Administration PageUse the Workspace Administration page to monitor and administer a workspace. Workspace Administration PageUse the Workspace Administration page to manage service requests, manageusers and groups, monitor activity, view dashboards, view the Utilization Report,change your password, manage interactive report settings, manage the ExportRepository, and request a new workspace. Resetting Your PasswordReset your password by clicking Change My Password under Tasks on theWorkspace Administration page.2-2

Chapter 2Understanding Workspace Administration Viewing Product Release and Environment InformationAccess the About APEX page to view basic product information, including the APEXrelease number, workspace name, environment details, and database information. Managing Export Files in the Current WorkspaceUse the Manage Export Repository to manage Export files in the current workspace. Managing Saved Interactive ReportsView and delete saved interactive reports as well as manage interactive reportsubscriptions. Viewing a Workspace SummaryUse the Workspace Utilization report to view a comprehensive summary of the currentworkspace, including summaries of schemas, applications, SQL Workshop scripts andresults, Team Development details, application activity, developer activity, and counts ofdatabase objects. Requesting a Workspace in Workspace AdministrationRequest 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 andmanage administrator tasks specific to a workspace.In Oracle APEX, users sign in to a shared work area called a workspace. A workspaceenables multiple users to work within the same APEX installation while keeping their objects,data and applications private. This flexible architecture enables a single database instance tomanage thousands of applications.Within a workspace,

2.7.1 About Oracle APEX Accounts Authentication 2-32 2.7.2 About Oracle APEX User Roles 2-32 2.7.3 Creating User Accounts 2-33 2.7.3.1 Creating a New User Account 2-33 2.7.3.2 Creating Multiple Users Simultaneously 2-35 2.7.4 Editing Existing User Accounts 2-36 2.7.5 Locking and Unlocking a User Account 2-37 2.7.6 Changing a User Account .