You can access the Websheet Properties page from inside or outside a running Websheet. Use the Websheet Properties page to control general application defaults and behavior. The home page identifies the home page users land on when running the Websheet. The name of the application is displayed within the breadcrumb.
See Also:
"Deleting a Websheet Application"To access the Websheet Properties page:
Log in to and run the Websheet. See "Running a Websheet."
From the Administration menu, select Websheet Properties.
The Websheet Properties appears.
To view a section, click the greater than sign (>
) to the left of the section title.
Edit the appropriate properties and click Apply Changes.
See Also:
"Websheet Properties"This section describes the attributes on the Websheet Properties page.
Use the Websheet section to control general Websheet application properties. Table 6-1 describes Application attributes.
Attribute | Descriptions |
---|---|
Identifies the name of the application. This name displays within the breadcrumb when the application is running. |
|
Identifies the status of the application. |
|
Select the home page for this Websheet. This is the first page a user sees when running the Websheet. |
|
Determines the date format to be used in the application. This date format is used to alter the |
|
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. |
|
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. |
|
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. |
|
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. |
Use the Details section to edit the application description and login message. Table 6-2 describes Details attributes.
Use the Logo section to create a logo for this Websheet application. This logo displays at the top of the Websheet. Table 6-3 describes Logo attributes.
Use the Authentication section to select an authentication scheme for this Websheet. Table 6-4 describes Authentication attributes.
Attribute | Descriptions |
---|---|
Select the way users of the application are authenticated. To change the authentication scheme, click Edit Authentication. The following list displays:
|
|
Specify a URL to become this application's Logout URL attribute. This attribute is referenced in logout links as follows:
If the application uses built-in session verification, you may use |
|
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. |
|
Path attribute for the session cookie. |
|
Domain attribute for the session cookie. |
|
Options include:
|
Use the Authorization section to control who can log in to a Websheet application. Table 6-5 describes Application attributes.
Attribute | Descriptions |
---|---|
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. |
|
Options include:
|
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."
Use the SQL section to 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.