Understanding Websheet Properties

Use the Websheet Properties page to control general application defaults and behavior.

Editing Websheet Properties

You can access the Websheet Properties page from inside or outside a running Websheet. The Home page identifies the default starting page users land on when running the Websheet.

To edit Websheet properties:

From the Application home 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.
From a running Websheet:
1. Run the Websheet.
2. From the Administration menu, select Websheet Properties.
The Websheet Properties appears.
To show or hide a section, click the greater than sign (>) to the left of the section title.
Edit the appropriate Websheet properties as described in the next section.
Click Apply Changes.

Websheet Properties

Developers use the Websheet Properties page to control general application defaults and behavior. The Home Page attribute identifies the page, data grid, or report that users will land on by default.

Parent topic: Understanding Websheet Properties

Websheet

Websheet properties control general Websheet application behavior.

Table 5-1 Websheet Properties

Attribute	Descriptions
Name	Identifies the name of the application. This name displays within the breadcrumb when the application is running.
Status	Identifies the status of the application.
Home Page	Select the home page for this Websheet. This is the first page a user sees when running the Websheet.
Application Date Format	Determines the date format to be used in the application. This date format is used to alter the `NLS_DATE_FORMAT` database session setting before showing or submitting any page in the application. This value can be a literal string containing a valid Oracle date format mask or an item reference using substitution syntax. If no value is specified, the default date format is derived from the database session at runtime.
Default Application Language	Identifies the default language of the application. Users are able to change their language preference from within the application. This language list is determined by the translated versions of Application Express which are installed.
Default Application Territory	Identifies the default territory of the application, which controls attributes like date language and numeric characters. Users are able to change their territory preference from within the application.
Show Reset Password	Controls the display of the Reset Password link on the Login page. This link enables users to reset their passwords. This option works only if the application is using Application Express Account authentication.
Websheet Email From Address	Determines the email address to use as the from address in the Websheet. This from email address is used when sending email from a data grid or report email download in the Websheet.

Parent topic: Websheet Properties

Details

Details properties determine the application description and login message.

Table 5-2 Details

Attribute	Descriptions
Owner	Identifies the user who owns the application.
Description	An optional description that describes the application.
Login Message	Display this message on the login page.

Parent topic: Websheet Properties

Logo

Use Logo properties to create a logo for a Websheet application. This logo displays at the top of the Websheet.

Table 5-3 Logo

Attribute	Descriptions
Logo Type	Select the type of logo being used for the application.
Logo	Enter a full text string to use as application logo.

Parent topic: Websheet Properties

Style

Use the Style section to override default application style and use a custom CSS.

Parent topic: Websheet Properties

Authentication

Use Authentication properties to select an authentication scheme for this Websheet.

Table 5-4 Authentication

Attribute	Descriptions
Authentication	Select the way users of the application are authenticated. To change the authentication scheme, click Edit Authentication. The following list displays: Application Express Account - Authenticate using developer account username and password. Single Sign-On - Authenticate using Oracle Application Server Single Sign-On. This must be configured for the Application Express instance. LDAP - Authenticate using an LDAP directory. Specify additional parameters on this page to configure this. Custom - Provide your own code for authentication and session management tasks. See "Controlling Websheet Access."
Logout URL	Specify a URL to become this application's Logout URL attribute. This attribute is referenced in logout links as follows: `&LOGOUT_URL.` If the application uses built-in session verification, you may use `"wwv_flow_custom_auth_std.ws_logout?p_websheet_app_id=&WS_APP_ID.&p_next_url=ws?p=&WS_APP_ID.:home"` to invoke a built-in logout procedure.
Type	Type of session cookie used. You can use this attribute to share the same Application Express session between multiple applications in a workspace. With session sharing, you can seamlessly navigate between applications without logging in multiple times. Application (No Sharing): The session cookie is specific to this application. Sessions are not shared with other applications. Workspace Sharing: The session is shared with other applications of this workspace, if these also set Cookie Type to Workspace Sharing. Custom: Define custom session cookie attributes.
Cookie Name	Name for the session cookie, which is required to identify an Application Express session and the session ID in the URL. If no value for the session cookie name is specified, Application Express picks a default value.
Cookie Path	Path attribute for the session cookie.
Cookie Domain	Domain attribute for the session cookie.
Secure	Options include: Yes - Allow the session management cookie to be sent from the browser only when the protocol is HTTPS. No - Allow the session management cookie to be sent from the browser when the protocol is HTTP or HTTPS.

Parent topic: Websheet Properties

Authorization

Authorization properties control who can log in to a Websheet application.

Table 5-5 Authorization

Attribute	Descriptions
Access Control List Type	If authentication is Application Express Account, choose whether authorization is determined by the role in the Application Express workspace, or if authorization is determined by the access control list. For all authentication types other than Application Express Account, authorization is always determined by the access control List.
Allow Public Access	Options include: Yes - Enable users to run the application in a read-only mode without requiring users to log in. No - All users must log in to run the application.

Attribute

Descriptions

Access Control List Type

If authentication is Application Express Account, choose whether authorization is determined by the role in the Application Express workspace, or if authorization is determined by the access control list. For all authentication types other than Application Express Account, authorization is always determined by the access control List.

Allow Public Access

Options include:

Yes - Enable users to run the application in a read-only mode without requiring users to log in.
No - All users must log in to run the application.

Tip:

Click Access Control Roles to learn more about roles and their privileges. Click Edit Access Control List to link to the Access Control List page. To learn more, see "Controlling Websheet Access."

Parent topic: Websheet Properties

SQL

SQL properties determine if users can use SQL in the current Websheet. By default, this capability is disabled. To change the default setting, select Yes.

If enabled, users can use SQL tags and SQL reports within the application. Click Add Object to link to the Suggestion Objects page. Users can write custom reports and use SQL tags on database objects within the schema associated with the current workspace. Identifying a database table or view as a Suggested Object makes it easier to write SQL by exposing the table and view columns in the help page.

Tip:

Instance administrators can control the ability to use SQL for an entire instance. To learn more, see "Enabling and Disabling SQL Access in Websheets" in Oracle Application Express Administration Guide.

Parent topic: Websheet Properties