6.10 Controlling Websheet Access

This section describes how to control access to a Websheet application.

6.10.1 How Websheet Access Works

An administrator controls who can log in to a Websheet application by specifying one of the following authentication mechanisms:

  • Public access (no authentication)

  • Oracle Application Express Account

  • Single Sign-On Verification

  • LDAP Credentials Verification

  • Custom

If authentication is defined as Custom, an access control list manages the privileges of this application's users.

If authentication is Oracle Application Express Account, you must specify whether authorization is determined by the user role defined in the Application Express workspace, or if authorization is determined by the access control list. For all authentication types other than Oracle Application Express Accounts, authorization is always determined by the access control list.

Once a user logs in to an application, a user's assigned role determines access. User assigned roles include:

  • Reader - May view, but not edit content.

  • Contributor - May view and edit content.

  • Administrator - May view and edit content and edit Websheet Properties and manage the Access Control List.

To learn more about user roles and privileges, click Help and then select Access Control.

6.10.2 Specifying the Access Control List Type

To use an access control list, you must edit the Websheet Properties and define the Access Control List Type as Custom.

To access the Websheet Properties page:

  1. On the Workspace home page, click the Application Builder icon.

  2. Click the Websheet Applications tab.

  3. Click the View Icons button.

  4. Locate the Websheet and click Edit.

    The Websheet Properties appears. See "Websheet Properties."

  5. Scroll down to Authorization.

  6. From Access Control List Type, select Custom.

  7. Click Apply Changes.

See Also:

"Authentication"

6.10.3 Creating Access Control List Entries

To create access control list entries:

  1. Log in to and run the Websheet. See "Running a Websheet."

  2. From the Administration menu, select Access Control.

  3. Click Create Entry.

    The Entry Details page appears.

  4. On the Entry Details page:

    1. Username - Enter the username of the user for whom you want to control access.

    2. Privilege - Identify the user's privileges:

      • Reader - May view, but not edit content.

      • Contributor - May view and edit content.

      • Administrator - May view and edit content and edit Websheet Properties and manage the Access Control List.

  5. Click either Create or Create and Create Another.