Skip Headers
Oracle® HTML DB User's Guide
Release 1.6

Part Number B14303-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

13 Managing a Development Workspace

In the Oracle HTML DB development environment, developers log in to a shared work area called a workspace. Users are divided into two primary roles: developer and workspace administrator.

Developers can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports. Workspace administrators additionally can create and edit user accounts, manage groups, manage development services. This section describes how to access many of these reports and perform Workspace administrator tasks.

This section contains the following topics:

Understanding Administrator Roles

In an Oracle HTML DB development environment there are two different administrator roles:

A Workspace administrator uses the Workspace Administration list, located on the Workspace home page, to manage their workspace. In contrast, an Oracle HTML DB administrator is a superuser that manages the entire hosted instance. In order to become a Workspace administrator, an existing administrator must give the developer administrator privileges on the Edit User Page.

See Also:

"Managing an Oracle HTML DB Hosted Service" for more information administering a workspace as an Oracle HTML DB administrator

About the Workspace Administration List

The Workspace Administration list displays on right side of the Workspace home page. Both developers and workspace administrators have access to the following links:

Additionally, workspace administrators have access to the Manage Users and Manage Service links.

See Also:

Changing Your Password

All users can change their password using the Change Password page.

To change your password:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Change Password.

  3. Type a new password in the Password field and then retype the password in the Confirm Password field.

  4. Click Apply Changes.

Note:

All users (developers and administrators) can use the Change Password link on the Oracle HTML DB home page to reset their password.

Monitoring Workspace and User Activity

Both developers and workspace administrators can monitor workspace utilization and user activity by selecting reports on the Monitor page. To view counts of application changes by developer users can access the Developer Activity Log.

This section contains the following topics:

Viewing Workspace and User Activity Reports

The Monitor page displays links to a variety of page and application reports, including top views, page view statistics, top application changes, and application change statistics.

To access the Monitor page:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Workspace Reporting, click Monitor Activity.

    The Monitor page is divided into the following sections:

    • Top Views

    • Page View Statistics

    • Top Changes

    • Application Change Statistics

  4. Select a report to review

Viewing Application Changes by Developer and Day

The Developer Activity Log displays counts of application changes by developer, by day, and application.

To view Developer Activity Log:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Logs.

  4. Click Monitor Developer Activity Log.

  5. Specify a time frame, the appropriate number of rows, and click Go.

    By default, the Developer Activity by Developer by Day report appears.

  6. To view additional details, select a user ID.

  7. To view additional activity reports, click one of the following buttons at the top of the page:

    • Application Changes by Month

    • Application Changes by Day Report

    • Application Changes by Day Link Chart

Purging Log Files

The Developer Activity Log track changes to applications within the current workspace. Log entries older then one month are automatically deleted. You can manually purge developer logs and the External Count Clicks log on the Log files page.

See Also:

"Managing Logs" for more information deleting log files as an Oracle HTML DB administrator

Purging the Developer Activity Log

To purge the Developer Activity Log:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Logs.

  4. Click Purge Dev. Log.

Purging the External Clicks Log

The External Clicks Log counts clicks from an Oracle HTML DB application to an external site. You can implement this functionality using COUNT_CLICK procedure.

To purge the External Clicks Log:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Logs.

  4. Click Purge Click Log.

Viewing Application and Schema Reports

Application and schema reports are available to all users. Application Reports offer useful information about the size, scope, and content of the applications being developed in a workspace. Schema Reports offer summaries of database privileges by schema as well as a list of all database schemas available in the current workspace.

To view application and schema reports:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

    The Administration Services page appears.

  3. From the Tasks list on the right side of the page, select Application Reports.

    The Administrative Reports page appears.

  4. Select a report to review.

Managing Session State and User Preferences

A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique ID which the HTML DB engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. Sessions persist in the database until purged by an administrator.

Workspace administrators can purge session state or user preferences within their workspace on the Session State Management page. Developers can purge their session state and user preferences for the current session.

Topics in this section include:

Managing Session State and User Preferences for the Current Session

Workspace administrators and developers can use the Session State Management page to manage session state and user preferences for the current session.

To manage session state and user preferences for the current session:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Session State.

  4. When the Session State Management page appears, click Report, with an option to purge your current session.

  5. Under Session State you can:

    • Reset the session state for the current session by clicking Purge Session State.

    • View information about the current session by clicking View Session State.

  6. Under User Preferences, you can:

    • View preferences for the current user, by clicking View Preferences.

    • Reset user preferences for the current user by clicking Reset Preferences.

Purging Recent Sessions by Age

Sessions are used to maintain user state. Workspace administrators can purge existing sessions by age.

To purge existing session by age:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Session State.

  4. On the Session State Management page, select Purge existing sessions by age.

  5. Make a selection from the Sessions older than list.

  6. Click one of the following buttons:

    • Report Session. Generates a report detailing the total number of sessions for the workspace, the number of users, and the number of old sessions.

    • Purge Sessions. Purges existing sessions by age.

Viewing Session Details Prior to Removing Session State

Workspace administrators can determine whether to remove existing sessions by first reviewing session details on the Session State page.

To view session details prior to removing session state:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Session State.

  4. On the Session State Management page, select Report recent sessions with drilldown to session details.

  5. Select a session ID.

  6. When Session Information appears, click either:

    • Remove State

    • Remove Session

Viewing Preferences for a Specific User

Workspace administrators view preferences for a specific user on the Preferences Report.

To view the Preferences Report:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Session State.

  4. On the Session State Management page, select Report preferences for users.

    The Preferences Report page appears.

  5. To search for a specific user, enter a user name in the User field and click Go.

Purging Preferences for a Specific User

Workspace administrators purge preferences for a specific user on the Purge Preferences page.

To purge preferences for a specific user:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Session State.

  4. On the Session State Management page, select Purge preferences for a selected user.

    The Purge Preferences page appears.

  5. Select a specific user in the User field and click Report.

    The User Preferences for the selected user appear.

  6. To purge the displayed user preferences, click Purge User Preferences.

Managing Users

Workspace administrators can create new user accounts, manage existing user accounts, and change user passwords. User accounts are particularly useful if you are using HTML DB Authentication. HTML DB Authentication checks the username and password against the Oracle HTML DB account repository. The Oracle HTML DB account repository contains account information that developers and administrators when logging in to Oracle HTML DB applications.

Topics in this section include:

See Also:

"About HTML DB Account Credentials" for more information on implementing HTML DB Authentication

Creating New User Accounts

Workspace administrators create new user accounts on the Create User page.

To create a new user account:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

    The Manage Users page appears.

  3. Under Manage Users, click Create New User.

    The Create User page appears.

  4. Under User Identification, enter the appropriate information. Required fields are marked with a red asterisk (*).

  5. Under Developer Privileges, specify whether the user is a developer or an administrator.

    • User is a developer - These users can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports.

    • User is an administrator - Workspace administrators additionally can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services.

  6. Under User Groups, select an optional user group.

    You can use groups to restrict access to various parts of an application. Groups are primarily useful when using HTML DB Authentication.

  7. Click Create User or Create and Create Another.

Editing Existing User Accounts

Workspace administrators edit existing user accounts on the Edit User page.

To edit an existing a user account:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

    The Manage Users page appears.

  3. Under Manage Users, click Edit Users.

    The Edit Users page appears. On the Edit Users page, you can:

    • Create a new user by clicking Create

    • Search for an existing user by entering a search condition in the Find field and clicking Go

  4. To edit a user account, click the Edit icon.

    The Edit User page appears.

  5. Under Developer Privileges, specify whether the user is a developer or an administrator.

    Developers having administrator privilege have access to all tools and reports available on the Workspace Administration list. These users can also alter passwords of users within the same workspace.

  6. Under User Groups, select an optional user group.

    You can use groups to restrict access to various parts of an application. Groups are primarily useful when using HTML DB Authentication.

  7. Follow the on-screen instructions.

Changing a User Password

Workspace administrators can change the password of any user in their workspace.

To change a user password:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

    The Manage Users page appears.

  3. Under Manage Users, click Edit Users.

    The Edit Users page appears.

  4. Locate the appropriate user and click the Edit icon. You can search for an existing user by entering a search condition in the Find field and clicking Go.

    The Edit User page appears.

  5. Scroll down to Password, type a new password in the Password and Confirm Password fields, and click Apply Changes.

Managing Groups

Workspace administrators can create groups to restrict access to various parts of an application. Keep in mind, however, that groups are not portable over different authentication schemes. Groups are primarily useful when using HTML DB Authentication.

Topics in this section include:

See Also:

"About HTML DB Account Credentials" for more information on implementing HTML DB Authentication

Creating and Editing Groups

To create a new group:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

  3. Under Manage Groups, click Create New Group.

    The Create User Groups page appears.

  4. Specify a group name, description, and click Create Group.

To edit an existing group:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

  3. Under Manage Groups, click Edit Groups.

    The Create User Groups page appears.

  4. Click the Edit icon next to the appropriate group.

  5. Make the appropriate change and click Apply Changes.

Viewing Group Assignment Reports

To view a report of user group assignments:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Users.

  3. Under Manage Groups, click Report User Group Assignments.

    The User Groups Assignments Report appears.

Adding Users to and Removing Users from a Group

To add a user from a group:

  1. Navigate to the Edit User page:

    1. Navigate to the Workspace home page.

    2. From the Workspace Administration list, select Manage Users.

    3. Under Manage Users, click Edit Users.

      The Edit Users page appears.

    4. To edit a user account, click the Edit icon.

      The Edit User page appears.

  2. To add a user to a group:

    1. Scroll down to User Groups.

    2. Select a group from the Groups list.

  3. To remove a user to a group:

    1. Scroll down to User Groups.

    2. Deselect the selected group in the Groups list.

Managing Development Services

Workspace administrators can use the Provisioning Services section of the Administration Services page to:

Topics in this section include:

Viewing Current Workspace Status

Workspace administrators can view current workspace status on the Manage Development Services page.

To view current workspace status:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Manage Service.

    The Manage Development Services page appears.

  4. Select Report Utilization.

  5. Follow the on-screen instructions.

Requesting a Database Schema

To submit a request to the Oracle HTML DB administrator for a new database schema:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Manage Service.

    The Manage Development Services page appears.

  4. Select Request Schema.

  5. Follow the on-screen instructions.

Requesting Additional Storage

To submit a request to the Oracle HTML DB administrator for additional storage space for your workspace:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Manage Service.

    The Manage Development Services page appears.

  4. Select Request Storage.

  5. Follow the on-screen instructions.

Requesting Service Termination

To submit a request to the Oracle HTML DB administrator to terminate workspace service:

  1. Navigate to the Workspace home page.

  2. From the Workspace Administration list, select Manage Workspace.

  3. Under Administration Services, click Manage Service.

    The Manage Development Services page appears.

  4. Select Terminate Service.

  5. Follow the on-screen instructions and click Request Termination.