How to enable Audit trail settings for Spreadsheet to be modified by User without Admin rights?

How to enable Audit trail settings for Spreadsheet to be modified by User without Admin rights?

book

Article ID: KB0079111

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.4 and higher

Description

In Statistica tools|Options|Spreadsheets|Warnings there is a global option to turn on/off spreadsheet audit trail:
User-added image

When enabled, this option will turn on the audit trail for all new spreadsheets at their creation time.

In an Enterprise install, this option is tied to the corresponding Enterprise|System Options|Spreadsheets for audit trail and only administrators can turn this on or off at the global level:
User-added image

When enabled, non admin users cannot turn off the global option, nor can they turn it off for any particular spreadsheet.

When this global option is not set, any user can turn on or off the logging at the spreadsheet level via the dialog.

Also, spreadsheet Tools ribbon|Locking option makes it possible to lock and (optionally) password protect the locking settings for the audit trail such that no one may change the audit trail settings for a locked spreadsheet without first turning off the locking:
User-added image

Environment

Windows 7 and higher

Resolution

Resolution 1
1. Make sure that the option "Audit Trail" is OFF in Enterprise's system options.
2. Open Statistica with Admin user, create a spreadsheet, turn ON the audit trail and save the spreadsheet:
User-added image

3. Quit Statistica, open it again with non-admin user, open the spreadsheet above and verify that audit trail option can be turned on or off:
User-added image

4. Run the attached workspace with a simplified example of stopping the spreadsheet audit.  Execution of the workspace should be successful.
User-added image

Resolution 2
1. Make sure that the option "Audit Trail" is ON in Enterprise's system options.
2. Open Statistica with Admin user, create a spreadsheet, turn ON the audit trail and save the spreadsheet:
User-added image

3. Quit Statistica, open it again with non-admin user, open the spreadsheet above and verify that audit trail option can NOT be turned on or off.
User-added image

4.  Run the attached workspace with a simplified example of stopping the spreadsheet audit. The message will appear suggesting that only user with administrator rights can turn of the audit option:
User-added image



 

Issue/Introduction

This article demonstrates how to use Audit trail settings for Spreadsheet to allow Users without Admin rights to modify it.

Attachments

How to enable Audit trail settings for Spreadsheet to be modified by User without Admin rights? get_app