Administrator Timeout Controls

From Spreadsheet Server version 25.4.3, IT administrators can password-lock the SQL Timeout, Drill Down Timeout, and Query Timeout fields, preventing end users from modifying values that can impact transactional system performance. When a timeout field is locked, a lock icon appears next to the field. End users must enter the administrator password to edit the value. The field re-locks automatically after each update.

Key Details:

• Available in Spreadsheet Server version 25.4.3 and later
• Applies to SQL Timeout (Standard Options), Drill Down Timeout (Drill Down Options), and Query Timeout (Query Options)
• Lock behavior is consistent across both the Legacy UI and the New UI
• The feature must be enabled in the Application Configurator
• The administrator password is configured in the Passwords section of the Application Security tab in the Application Configurator

Prerequisites

• Spreadsheet Server version 25.4.3 or later
• Access to the Application Configurator

Enable Administrator Timeout Controls

To enable timeout locking for all users:

1. Open the Application Configurator.
2. Select the Application Security tab.
3. Under Disable Features, select the Timeout Settings (SQL, Drill Down, Query) checkbox.

   

4. In the Passwords section of the same tab, set the password that end users must enter when editing a locked timeout field.

5. Click Save.

Locked Timeout Fields

When timeout locking is enabled, a lock icon appears next to each protected field in Spreadsheet Server. The three fields and their locations are as follows:

SQL Timeout — Settings > General > Standard Options

Drill Down Timeout — Settings > General > Drill Down Options

Query Timeout — Settings > Query > Query Options

Edit a Locked Timeout Field

To update the value of a locked timeout field:

1. Click the locked timeout field.

2. In the Admin Feature prompt that appears, read the message: This feature requires a password.

   

3. Enter the administrator password and select OK.

4. In the dialog box that appears, enter the new timeout value in seconds.

   

5. Select OK.

The field updates and re-locks automatically. The password is required again for any future edits.