Managing Workspace Preferences

Disabling PL/SQL Program Unit Editing for a Workspace

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 Preferences page.

To disable PL/SQL program unit editing:

1. Navigate to the Workspace home page.

2. Click Manage Services on the Administration list.

   The Manage Services page appears.

3. Click Set Workspace Preferences.

   The Set Workspace Preferences page appears.

4. Under PL/SQL Editing, select one of the following:

   • Allow PL/SQL program unit editing

   • Do not allow PL/SQL program unit editing

   If you select Do not allow PL/SQL program unit editing, developers can still create and replace PL/SQL program units using scripts or SQL Commands.

5. Click Apply Changes.

Enabling Login Controls for a Workspace

There are two different ways to configure login controls:

• An Oracle Application Express administrator enables account login controls for all Application Express accounts in all workspaces across a development instance.

  If your Oracle Application Express administrator configures these preferences for an instance, those settings display as the defaults for all workspaces. See "Enabling Login Controls for All Workspaces".

• If the Oracle Application Express administrator does not enable login controls across an entire instance, then each Workspace administrator can enable the following controls on a workspace-by-workspace basis:

  • Require end-user account expiration and locking

  • Set up a maximum number of failed login attempts for end-user accounts

  • Set the password lifetime for end-user accounts, that is, the number of days an end-user account password can be used before it expires

To enable login controls for a workspace:

1. Navigate to the Workspace home page.

2. Click Manage Services on the Administration list.

   The Manage Services page appears.

3. Under Workspace Preferences, click Set Workspace Preferences.

4. Under Account Login Control:

   1. Account Expiration and Locking - Click Enable.

      If you select Enable, end-user account passwords will expire after a configurable time period, accounts will be locked after a configurable number of authentication failures, and account passwords can be set to expire after the first use.

      If your Oracle Application Express administrator set the Require User Account Expiration and Locking preference to Yes, this preference defaults to Enable and you cannot update it.

   2. Maximum Login Failures Allowed - Enter a number for the maximum number of consecutive unsuccessful authentication attempts allowed before an end-user account is locked. If you do not specify a value in this field, the instance-level setting for Maximum Login Failures Allowed is used.

   3. User Account Lifetime (days) - Enter a number for the maximum number of days an end-user account password may be used before the account expires. If you do not specify a value in this field, the instance-level setting for Account Password Lifetime is used.

5. Click Apply Changes.

Specifying a Workspace Message

You can display a message on the workspace home page by defining a Workspace Message on the Set Workspace Preferences page.

To define a workspace message:

1. Navigate to the Workspace home page.

2. Click Manage Services on the Administration list.

   The Manage Services page appears.

3. Click Set Workspace Preferences.

   The Set Workspace Preferences page appears.

4. Under Workspace Message, enter a message in the Message field. To format the display include standard HTML tags.

5. Click Apply Changes.