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:
In an Oracle HTML DB development environment there are two different administrator roles:
A Workspace administrator uses HTML DB Workspace Administration 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 |
You access Workspace Administration by clicking the Administration icon on the Workspace home page. On the Workspace Administration page, both developers and workspace administrators have access to the Monitor Activity icon. This icon links to the Monitor page where users can view a variety of Page View and Application Changes reports.
Additionally, workspace administrators have access to these icons:
Manage Service links to the Mange Services page. Use this page view workspace information as well as submit requests to the Oracle HTML DB administrator for a new database schema, additional storage, or to terminate workspace service.
HTML DB Users links to Manage Users page. Use this page to create new user accounts, manage existing user accounts, and change user passwords.
A Tasks list displays on the right side of the HTML DB Workspace Administration page. Both developers and workspace administrators have access to the following links:
About HTML DB links to an About page that lists basic product information including the product version, schema compatibility, application owner, workspace information, current user name, language preference, and database version.
Change Password links to a page where users can change their workspace password.
|
See Also: "Changing Your Password", "Monitoring Activity", "Managing Users" , "Managing Groups", "Managing Services", and "Managing an Oracle HTML DB Hosted Service" for more information administering a workspace as an Oracle HTML DB administrator |
All users can change their password using the Change Password page.
To change your password:
Navigate to the Workspace home page.
Click the Administration icon.
From the Tasks list, select Change Password.
Type a new password in the Password field and then retype the password in the Confirm Password field.
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. |
Both developers and workspace administrators can monitor changes to page views and entire applications by viewing reports on the Monitor page.
Topics in this section include:
To access the Monitor page:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
The Monitor page is divided into the following sections:
Page Views
Application Changes
Sessions
Select a report to review.
To view application changes by developer:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Application Changes, select By Developer.
Specify a time frame. Make a selection form the Time list and click Go.
To view additional details, select a user ID.
To view application changes by developer:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Application Changes, select By Application.
Specify a time frame. Make a selection form the Time list and click Go.
To view additional details, select an application ID.
The Active Sessions Report is only available to Workspace administrators. This displays active sessions for the current workspace.
To view application changes by developer:
Navigate to the Workspace home page.
Click the Administration icon.
Click Monitor Activity.
Under Sessions, select Active Sessions.
Select the session ID to view the Session Details page.
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 information about implementing HTML DB Authentication and "Managing Groups" |
Workspace administrators create new user accounts on the Create User page.
To create a new user account:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage HTML DB Users.
The Manage HTML DB Users page appears.
Click Create End User.
The Create User page appears.
Under User Identification, enter the appropriate information. Required fields are marked with a red asterisk (*).
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.
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.
Click Create User or Create and Create Another.
Workspace administrators edit existing user accounts on the Edit User page.
To edit an existing a user account:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage HTML DB Users.
The Manage HTML DB Users page appears.
Click Existing Users.
The Existing Users page appears. You control how the page displays by making a selection from the View list. Available options include:
Icons (the default) displays each user as a large icon. To edit a user, click the appropriate icon.
Details displays each user as a line in a report. To edit a user, click a user name.
The Edit User page appears.
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.
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.
Follow the on-screen instructions.
Workspace administrators can change the password of any user in their workspace.
To change a user password:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage HTML DB Users.
The Manage HTML DB Users page appears.
Click Existing Users.
The Existing Users page appears.
To search for an existing user, enter a query in the Find field and clicking Go.
Select a user.
Scroll down to Password, type a new password in the Password and Confirm Password fields, and click Apply Changes.
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 information about implementing HTML DB Authentication and "Managing Users" |
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage HTML DB Users.
Click Create Group.
The Create/Edit Group page appears.
Specify a group name, description, and click Create Group.
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage HTML DB Users.
Click Existing Groups.
The Existing Groups page appears.You control how the page displays by making a selection from the View list. Available options include:
Icons (the default) displays each group as a large icon. To edit a group, click the appropriate icon.
Details displays each group as a line in a report. To change the group name or description, click the appropriate name.
Make the appropriate change and click Apply Changes.
To view a report of user group assignments:
Navigate to the Workspace home page.
Click the Administration icon.
Click Mange HTML DB Users.
Click User Group Assignments.
The User Groups Assignments report appears.
Navigate to the Workspace home page.
Click the Administration icon.
Click Mange HTML DB Users.
Click Existing Users.
The Existing Users page appears.
Select a user.
The Edit User page appears.
Scroll down to User Groups.
Select a group from the Groups list.
Click Apply Changes.
Navigate to the Workspace home page.
Click the Administration icon.
Click Mange HTML DB Users.
Click Existing Users.
The Existing Users page appears.
Select a user.
The Edit User page appears.
Scroll down to User Groups.
Deselect the selected group in the Groups list.
Click Apply Changes.
Workspace administrators use the Managing Services page to view reports about the current workspace and associated schemas, manage session state, purge log files, terminate a workspace service, or request a new schema or additional storage.
Topics in this section include:
Workspace administrators can view a summary report about the current workspace by selecting Workspace Overview on the Manage Services page.
To view a summary report about the current workspace:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services and Workspace Overview.
Follow the on-screen instructions.
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.
Topics in this section include:
Workspace administrators 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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
When the Session State Management page appears, click Report your current session, with an option to purge.
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.
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.
Sessions are used to maintain user state. Workspace administrators can purge existing sessions by age.
To purge existing session by age:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
Select Purge existing sessions by age.
Make a selection from Sessions older than.
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.
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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Service.
Click Session State.
Select Report recent sessions with drilldown to session details.
To narrow the results, select a time increment, specify a user, and click Go.
Workspace administrators view preferences for a specific user on the Purge Preferences report.
To view the Purge Preferences report:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
On the Session State Management page, select Report preferences for users.
The Preferences Report page appears.
Specify a user and click Go.
Workspace administrators purge preferences for a specific user on the Purge Preferences page.
To purge preferences for a specific user:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Service.
Click Session State.
On the Session State Management page, select Purge preferences for a selected user.
The Purge Preferences page appears.
Select a specific user and click Report.
A report appears at the bottom of the page.
To purge the displayed user preferences, click Purge User Preferences.
Oracle HTML DB automatically deletes log entries older then one month. Workspace administrators 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 |
The Developer Activity Log track changes to applications within the current workspace.
To purge the Developer Activity Log:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Logs.
Click Purge Developer 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:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Logs.
Click Purge Click Log.
To submit a request to the Oracle HTML DB administrator to terminate workspace service:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Terminate Service.
Follow the on-screen instructions and click Request Termination.
To submit a request to the Oracle HTML DB administrator for a new database schema:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Request Schema.
Enter a new schema name and click Request Database Schema.
To submit a request to the Oracle HTML DB administrator for additional storage space for your workspace:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Request Storage.
Specify the amount of storage to add and click Request Storage.
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 Schema Reports:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Schema Reports.
Available Schema Reports include:
Database Privileges by Schema
Database Schemas Available for the Current Workspace
By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. You can disable PL/SQL program unit editing by selecting Do not allow PL/SQL program unit editing on the Workspace Preferences page.
To disable PL/SQL program unit editing:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Workspace Preferences.
The Workspace Preferences page appears.
From 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 the SQL Command Processor.
Running the Create Application Wizard creates an application model. This model contains basic application property values, such as the application pages and page definitions, DML processes, and multi-row operation processes. When you create a new application, you can base it on an existing application model, making the creation process more productive.
You can remove unwanted application models on the Application Models page.
To delete an application model:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Application Models.
The Application Models page appears.
To search for a model, enter a case insensitive query in the Model field and click Go.
Select the models you want to delete and click Delete Checked.