Lock down the Design mode for end-users

The Designer and Data Editor roles

To prevent end-users from selecting and setting up tables in the SQL Spreads Designer themselves, you can let a user run SQL Spreads in the Data Editor role/mode.

In Data Editor mode, all SQL Spreads Design-features will be locked out, and the user can only make changes to SQL Server data using SQL Spreads documents created by a user who are assigned the Designer role/mode.

The idea behind the Designer and Data Editor roles is that you should let a person with database knowledge create Excel spreadsheets for data maintenance, and then let your non-database skilled people use those data management Excel spreadsheets to manage the data.

How to activate SQL Spreads in Data Editor mode

The Data Editor mode/role is controlled by a license key. You will need to purchase a separate Data Editor license key for each of your end users that need to make changes to your SQL Spreads documents that your Designer has created.

Contact support@sqlspreads.com for assistance with purchasing additional Data Editor licenses for your team.