Configure workspace preferences for workspace login controls, access to App Builder and SQL Workshop, support for PL/SQL editing and RESTful services, and access to Team Development.
Tip:
You can access many workspace administration functions (such as Manage Service, Set Worksapce Preferences) from both the Administration menu and the Workspace Administration home page. For consistency, this section navigates the user to the Workspace Administration home page.
Tip:
Some workspace preferences can also be configured for an entire instance. If applicable, the section includes references to any instance-level settings.
Configure workspace login controls such as account expiration and locking, maximum number of failed login attempts, and password lifetime.
See Also:
Workspace administrators can configure login controls for an individual workspace.
Workspace administrators can also configure login controls for an entire Oracle Application Express instance. For example, if an Instance administrator configures account login controls in Oracle Application Express Administration Services that configuration applies to all Application Express accounts in all workspaces across an entire instance.
If the Instance administrator does not enable login controls across an entire instance, then each Workspace administrator can configure the following controls on a workspace-by-workspace basis:
End-user account expiration and locking
A maximum number of failed login attempts for end-user accounts
The password lifetime (or number of days an end-user account password can be used before it expires for end-user accounts
Tip:
This feature applies only to accounts created using the Application Express user creation and management. Application Accounts Authentication provides additional authentication security for applications. See "Managing Users in a Workspace."
Control whether developers can access App Builder.
To control access to App Builder:
Tip:
These settings can be overridden by an Instance administrator. See "Managing Component Availability for an Instance."
Control whether developers can access to SQL Workshop. SQL Workshop includes tools for viewing and managing database objects.
To control access to SQL Workshop:
Tip:
These settings can be overridden by an Instance administrator. See "Managing Component Availability for an Instance."
Determine whether developers have the ability to edit and compile PL/SQL program units from Object Browser.
By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in SQL Workshop Object Browser. Workspace administrators can disable PL/SQL program unit editing by selecting Do not allow PL/SQL program unit editing on the Set Workspace Preferences page.
To disable PL/SQL program unit editing:
See Also:
"Disabling PL/SQL Program Unit Editing for an Instance" and "Using SQL Commands" in Oracle Application Express SQL Workshop Guide
Workspace administrators can control whether RESTful Services are enabled in the current workspace.
Use the Enable RESTful Services attribute to control the ability to create and access RESTful Services mapped to SQL and PL/SQL. RESTful Services can also be enabled or disabled at the instance-level in the Administration Services application. Go to Manage Instance, Feature Configuration, and then SQL Workshop.
Tip:
RESTful Services requires that the web listener in your configuration uses Oracle REST Data Services release 2.0 or later.
To configure RESTful access:
See Also:
"Configuring SQL Workshop " to learn about enabling RESTful Services at the instance-level in the Administration Services application
"Enabling Data Exchange with RESTful Services" in Oracle Application Express SQL Workshop Guide
Use the options under Team Development to specify whether Team Development is available in the current workspace, enable support for file attachments, and specify the maximum size of uploaded files.
Tip:
The Enable File Repository attribute can only be modified if the instance-level setting, Enable Team Development's File Repository is set to Yes. See "Enabling Instance-level Support for File Upload in Team Development."
Control whether developers can access Team Development.
To enable Team Development: