14 Administering Workspaces

This section describes tasks an Oracle HTML DB administrator performs when administering workspaces.

This section contains the following topics:

• About the Oracle HTML DB Administrator

• Viewing Workspace Reports

• Creating a Workspace

• Managing Users in a Workspace

• Managing the Schemas Associated with a Workspace

• Removing a Workspace

• Exporting and Importing a Workspace

About the Oracle HTML DB Administrator

In the Oracle HTML DB development environment, users log in to a shared work area called a workspace. Users are divided into three primary roles:

• Developer

• Workspace administrator

• Oracle HTML DB administrator

A developer can create and edit applications. A Workspace administrator performs administrator tasks specific to their workspace such as managing user accounts, monitoring workspace activity, and viewing log files. An Oracle HTML DB administrator manages an entire Oracle HTML DB development environment instance. To perform these tasks, an Oracle HTML DB administrator logs into the Oracle HTML DB Administration Services application. Your Oracle HTML DB Administration Services application can be found at the following location:

http://server:port/pls/Database Authentication Descriptor/htmldb_admin

See Also: Oracle HTML DB Quick Installation Guide for your platform for more information on installing Oracle HTML DB

Viewing Workspace Reports

Oracle HTML DB administrators can view detailed information about a specific workspace by viewing the Workspace Utilization Report.

To view a workspace report:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Report Workspace Attributes.

3. Select a workspace from the Workspace list and click Go.

   The Workspace Utilization Report appears. Table 14-1 describes the various sections of the Workspace Utilization Report.

Table 14-1 Workspace Utilization Report

Report	Description
Workspace Information	Enables administrators to edit workspace information.
Workspace Schemas and Default Tablespaces	Enables administrators to manage workspace to schema mappings. See Also: "Managing the Schemas Associated with a Workspace"
Workspace Schemas Utilizing Space in Tablespaces	Displays a report that details tablespace utilization.
Applications	Displays a report that lists all applications within the current workspace.
Application Developers	Displays a report that lists all application developers within the current workspace.
Cookie Users	Enables administrators to manage user accounts. See Also: "Managing Users in a Workspace"
Objects Used By Workspace	Displays a report that lists objects used in the current workspace.
Service Change Requests	Enables administrators to manage change requests for the current workspace, or to view a report of all change requests in an Oracle HTML DB development instance. See Also: "Managing a Service and Change Request"
Developer Activity	Displays a report that details developer activity by date.

Creating a Workspace

When a user logs into the Oracle HTML DB they log in to a shared work area called a workspace. Each workspace is an area within the Oracle HTML DB development environment where multiple developers can create applications. Each workspace has a unique ID and name. In order to make changes to their workspace, Workspace administrators submit change request to an Oracle HTML DB administrator. Only an Oracle HTML DB administrator can create a new workspace.

Topics in this section include:

• Specifying a Provisioning Mode

• Managing a Service and Change Request

• Creating a Workspace Without a Request

See Also: "Managing Development Services"

Specifying a Provisioning Mode

As an Oracle HTML DB administrator, you determine how the process of creating (or provisioning) a workspace works for your Oracle HTML DB development environment.

In manual provision mode, an Oracle HTML DB administrator creates new workspaces and notifies the Workspace administrator of the login information. In request provision mode, users request workspaces directly using an automated process. In this scenario, users use a link on the login page to access a request form. Once the workspace request has been granted, they are e-mailed the appropriate login information.

To specify a provisioning mode:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage HTML DB Service, select Toggle Provisioning Status.

3. Select one of the following:

   • Manual

   • Request

4. Click Apply Changes.

Note: Before users can request a workspace or change their passwords, an Oracle HTML DB administrator must configure engine settings. For more information, see "Managing Engine Settings".

Managing a Service and Change Request

Oracle HTML DB administrators can make modifications to a workspace (such as such as adding an additional schema or increasing the disk space limit) by approving a change request from a Workspace administrator.

Viewing a Pending Service or Change Request

You can view a summary of pending service requests and change requests in the Notifications list on the Administration home page.

To view pending service and change requests:

1. Log in to Oracle HTML DB Administration Services.

2. Locate the Notifications list on the lower right side of the page (See Figure 14-1).

   Figure 14-1 Notifications List

   
   Description of the illustration notifi.gif
   
   

   The Notifications list displays a summary of total and pending service and change requests.

3. To view additional details, click the appropriate service request or change request number.

   The appropriate Change Request page appears.

To view pending requests from the Workspace Administration tab:

1. Log in to Oracle HTML DB Administration Services.

2. Select the Workspace Administration tab.

3. Locate a workspace as follows:

   • To locate a specific workspace, type the workspace name in the Search field and click Go.

   • To view all workspaces, leave the Search field blank and click Go.

4. Click the view icon to the left of the appropriate workspace name.

   The Workspace Utilization Report appears.

5. Under Available Reports, click Service Change Requests.

6. Select a specific request, or click View All Change Requests.

Approving a Service or Change Request

To approve a pending service request:

1. Navigate to the Service Change Request page as described in "Viewing a Pending Service or Change Request".

2. Click Provision.

   The Provisioning Administration page appears.

3. Select one of the following:

   • To approve the request, click Approve.

   • To decline the request, click Decline.

4. Follow the on-screen instructions.

To approve a pending change request:

1. Navigate to the Service Change Request page as described in "Viewing a Pending Service or Change Request".

2. Click View Request.

   The Process Change Request page appears.

3. Review the displayed reports.

4. Select one of the following:

   • To approve a request for a schema, click Create Schema.

   • To approve a request for additional disk space, click Provision Space.

   • To approve a request to terminate the service, click Terminate Service

5. To deny a request, click Deny Request.

6. Follow the on-screen instructions.

Creating a Workspace Without a Request

Administrators can create a workspace manually by running the Provision Workspace Wizard. You can access this wizard from either the Oracle HTML DB Administration Services Home page or the Workspace Administration tab.

To create a workspace manually:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Create New Workspace.

   The Provision Workspace Wizard appears.

3. Specify a workspace name, ID, and description and click Next.Select a schema, or enter the name for a new schema, followed by a password, and initial disk space quota.

4. Click Next.

5. Specify a Workspace administrator by providing a username, password, and e-mail address and click Next.

6. Confirm your selections and click Provision.

Managing Users in a Workspace

Oracle HTML DB administrators can manage all user accounts within an Oracle HTML DB instance on the Manage Application Developers and Users page. User accounts are particularly useful if a workspace utilizes internal "Cookie User" authentication.

See Also: "Managing Your Development Workspace" "About HTML DB Account Credentials" for more information on implementing internal Cookie User (or HTML DB Account Credentials) authentication.

To create a new user account:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Manage Application Developers.

   The Manage Application Developers and Users page appears.

3. Click Create.

4. Under User Attributes, enter the appropriate information. Fields marked with a red asterisk (*) are required.

5. Under Password, type a case sensitive password for this account.

6. Under Developer Privileges, specify the developer's privileges.

   Developers having the Admin privilege have access to the Administration Services page and all the functionality described in "Managing Your Development Workspace".

7. Click Create or Create and Create Another.

To edit an existing user account:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Manage Application Developers.

   The Manage Application Developers and Users page appears.

3. Locate a user as follows:

   • To locate a specific user, type a username in the Search field and click Go.

   • To view all users, leave the Search field blank and click Go

4. Click the edit icon adjacent to appropriate username.

5. Follow the on-screen instructions.

Managing the Schemas Associated with a Workspace

A workspace can have multiple associated schemas. By associating a workspace with a schema, you can:

• Build applications that interact with the database objects in that schema.

• Create new database objects in that schema.

To view the schema associated with a workspace:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Manage Schema to Workspace Assignments.

   The Schemas Provisioned by Workspace page appears.

3. To view information about an existing schema, click the edit icon.

4. To create a new schema association, click Create.

5. Follow the on-screen instructions.

Removing a Workspace

Removing a workspace does not remove the associated schema or schemas. To remove the associated schemas, a database administrator (DBA) must use a standard database administration tool such as Oracle Enterprise Manager or SQL*Plus.

See Also: Oracle Enterprise Manager Administrator's Guide SQL*Plus User's Guide and Reference

To remove a workspace:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Remove Workspace.

3. Select a workspace name and click Next.

4. Follow the on-screen instructions.

Exporting and Importing a Workspace

To move a workspace and all associated users to a new Oracle HTML DB development instance, you must export the workspace. When you export a workspace, Oracle HTML DB generates a text file. This file contains information about your workspace, all the users in your workspace, and any groups in your workspace (if applicable). You can use this file to import your workspace into another Oracle HTML DB instance.

Keep in mind, this method only imports workspace, users, and groups. This file does not contain:

• The schemas associated with this workspace, or the objects in those schemas.

• Any applications, images, cascading style sheets and static text files.

All of these items must be exported separately.

See Also: "Exporting and Importing Applications" "About Managing Database Objects" "Uploading CSS, Images, and Static Files"

To export a workspace:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Export Workspace.

3. Select a workspace name and click Export.

4. To export the selected workspace, click Save File.

5. Follow the on-screen instructions.

To import a workspace:

1. Log in to Oracle HTML DB Administration Services.

2. Under Manage Workspaces, select Import Workspace.

3. Select a workspace name and click Next.

4. To install the workspace, click Install.

5. Follow the on-screen instructions.