Step 10: Application Security

Application security contains criteria to control encryption of files, disabling of features in Spreadsheet Server, and changing system-delivered passwords used to access and/or process various functions in Spreadsheet Server.

From the Application Configurator panel, select the Application Security tab. The Application Security panel appears.
From the Application Configurator panel, select the Application Security tab. The Application Security panel appears.
Use the following table to enter data in the Application Security panel:

Field	Description
Security Options:
Encrypt Files (requires associated password to be changed from default value):
Security and Connection Files	If selected, the system encrypts the security and connection files. The Administrator Login password must be specified.
Designer GL Files	If selected, the system encrypts the Designer GL files. The Designer GL: Browse for GL Definition Button password must be specified.
Ad Hoc Files	If selected, the system encrypts the ad hoc files. The Ad Hoc Queries: Editing password must be specified.
Query Files	If selected, the system encrypts the query (`EDQ`) files.
Disable Features:
Ad Hoc Queries	If selected, all ad hoc query options are unavailable for all users.
Designer GL	If selected, all Designer GL options are unavailable for all users.
AI Feature Controls: (Available from v25.4 onwards)
Disable AI Doc Assist	If selected, the AI Doc Assist feature is unavailable for all users.
Disable AI Data Assist	If selected, the AI Data Assist feature is unavailable for all users. This option is only available for Platform customers.
Passwords:
Application Configurator:
Administrator Login Screen	Specify the password to be entered in the Administrator Login dialog, when opening Spreadsheet Server. Type the same password in the associated Confirm Password field.
Settings:
General: Network Security & Connections File Browse Button	Specify the password to be entered when assigning the location of the network security and connection files in the General Settings panel. Type the same password in the associated Confirm Password field.
Ledger Specifics:
Designer GL: Browse for GL Definition Button	Specify the password to be entered when retrieving a Designer GL definition in the Ledger Specifics > Designer GL Settings panel. Type the same password in the associated Confirm Password field.
Oracle: Set Segment Number for All Ledgers Button	Specify the password to be entered to process the function of assigning the same segment number used for descriptions, to all ledgers (sets of books) in the Ledger Specifics > Oracle Settings panel. Type the same password in the associated Confirm Password field.
SAP: Special Ledgers Option	Specify the password to be entered to access the SAP Special Ledgers panel in the Settings function. Type the same password in the associated Confirm Password field.
Ad Hoc Queries: Editing	Specify the password to be entered to edit ad hoc queries in the Ad Hoc Queries Settings panel. Type the same password in the associated Confirm Password field.
Segment List Maintenance:
Cleanup Segment List Database Toolbar Button	Specify the password to be entered to process the Cleanup Segment List Database function in the Segment List Maintenance panel. Type the same password in the associated Confirm Password field.
Unlock Segment List Toolbar Button Override	Specify the password to be entered when unlocking segment list(s), and the individual segment list password(s) is lost or forgotten. Type the same password in the associated Confirm Password field.
Accounts Profile:
Unlock Accounts Profile Button Override	Specify the password to be entered when unlocking account profiles, and the password is lost or forgotten. Type the same password in the associated Confirm Password field.

Click Save, then Yes, to push the changes to the network location.

AI Feature Controls - Detailed Configuration

The AI Feature Controls allow administrators to manage which AI capabilities are available to users. The default behavior leaves AI features enabled.

Disabling AI Features

Open the Application Configurator and navigate to the Application Security tab.
Locate the Lineos AI Features Controls section.
Check the boxes to disable one or both AI capabilities.
Click Save and push changes to the network.
Close and reopen Excel for changes to take effect.

Configuration Scenarios

Just AI Data Assist Disabled

When AI Data Assist is disabled, users retain access to AI Doc Assist for documentation assistance, while AI Data Assist features for data analysis remain unavailable.

Just AI Doc Assist Disabled

When AI Doc Assist is disabled, users retain access to AI Data Assist for data analysis assistance, while AI Doc Assist features for documentation remain unavailable.

Both AI Doc Assist and AI Data Assist Disabled

When both features are disabled, no AI capabilities are available in Spreadsheet Server. This configuration is suitable for organizations with strict AI policies that prohibit the use of AI features.

Note: Some organizations may not have concerns enabling AI Doc Assist but might have policies restricting AI Data Assist. The controls provide flexibility to enable or disable features based on organizational requirements.