Controlling Websheet Access

Control access to a Websheet application by selecting an authentication mechanism (such as Oracle Application Express Account, Single Sign-On Verification, or LDAP Credentials Verification), or by creating a custom access control list.

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.

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 App Builder icon.
  2. On the App Builder home page appears, select the Websheet application.
    The Websheet Properties appears.
  3. Under Authorization:
    1. Access Control List Type - Select Custom.
    2. Allow Public Access - When set to Yes to enable users to run the application in a read-only mode without requiring users to log in. When set to No, all users need to log in to run the application.
  4. Click Apply Changes.

See Also:

"Authentication"

Creating Access Control List Entries

To create access control list entries:

  1. Run the 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 - Identify the username that you wish to control access for.
    2. Privilege - Identify the privilege level for the user. If the application is using custom authorization, the access control list manages the privileges of this application's users. Option 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.

  5. Click either Create or Create and Create Another.

See Also:

"Running a Websheet"