Managing Environment Settings

Viewing Current Environment Settings

To view existing environment settings:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Scroll down to the bottom of the page and select Settings.

   The current selected settings appears

Controlling PL/SQL Program Unit Editing

By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. You can control PL/SQL program unit editing for an entire workspace by making a selection from Allow PL/SQL Program Unit Editing.

To disable PL/SQL program unit editing:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Locate the section Application Development.

5. From Allow PL/SQL Program Unit Editing, select No.

6. Click Apply Changes.

Including Demonstration Applications in a New Workspace

When you create a new workspace, Oracle HTML DB automatically creates demonstration applications within the workspace.

To disable the creation of demonstration applications:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Locate the section Application Development.

5. From Create demonstration objects in new workspaces, select No.

6. Click Apply Changes.

Configuring Oracle HTML DB to Send Mail

To enable users to request a workspace or reset their passwords using links on the login page, you must configure Oracle HTML DB to send mail. In order to enable Oracle HTML DB to send mail, you must configure a number of settings on the Environment Preferences page.

To configure Oracle HTML DB to send mail:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Under Email, enter the following:

   1. SMTP Host Address - Defines the server address of the SMTP server. On installation, this will be set to localhost. If you are using another server as an SMTP relay, change localhost to that server's address.

   2. SMTP Host Port - Defines the port the SMTP server listens to for mail requests. By default, this setting will be set to 25 at the time of installation.

   3. Administration Email Address - Defines the "from" address for administrative tasks such as approving a provision request, or resetting a password generates an e-mail.

5. Click Apply Changes.

Configuring SQL Workshop

Use the attributes under SQL Workshop to configure basic SQL Workshop behavior.

To configure SQL Workshop:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Under SQL Workshop, enter the attributes described in Table 22-2.

   Table 22-2 SQL Workshop Attributes

   Attribute	Description
   SQL Commands Maximum Inactivity in minutes	Identify the maximum amount of time a transactional command in the SQL Command Processor waits before timing out.
   SQL Scripts Maximum Script Output Size in bytes	Identify the maximum amount of output a single SQL script can generate. SQL scripts are run from the SQL Workshop.
   SQL Scripts Maximum Workspace Output Size in bytes	Identify the maximum amount of space all scripts within a workspace may consume. SQL script results are the output generated when running SQL scripts from the Script Editor or from the SQL Scripts home page.
   SQL Scripts Maximum Script Size in bytes	Identify the maximum size of a SQL script used within the SQL Workshop.
   Enable Transactional SQL Commands	Select Yes to enable transactional SQL commands for the entire Oracle HTML DB instance. Enabling this feature permits SQL Command Processor users to issue multiple SQL commands within the same physical database transaction. When you select Yes, an Autocommit check box appears on the SQL Command Processor page. By default, this option is set to No.

   
   

5. Click Apply Changes.

Enabling Database Monitoring

The Database Monitoring page contains a variety of reports that describe the activity, storage, and configuration of the current database instance. Once enabled, only users having a database user account that has been granted a DBA role can access the Database Monitor page.

Before you can access the Database Monitoring page, you must enable database monitoring on Manage Environment Settings page.

To enable database monitoring:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. From Enable Database Monitoring, select Yes.

5. Click Apply Changes.

Configuring Security Settings

Use the Security section of the Manage Environment Settings page to disable administrator and workspace login as well as restrict user access by IP address.

Topics:

• Disabling Access to Oracle HTML DB Administration Services

• Disabling Access to Oracle HTML DB Internal Applications

• Restricting User Access by IP Address

BEGIN
    WWV_FLOW_API.SET_SECURITY_GROUP_ID(p_security_group_id=>10);
    WWV_FLOW_PLATFORM.SET_PREFERENCE( 
        p_preference_name => 'DISABLE_ADMIN_LOGIN',
        p_preference_value => 'N' );
end;
/

commit
/