Lock down the Design mode for end-users
    • Dark
      Light
    • PDF

    Lock down the Design mode for end-users

    • Dark
      Light
    • PDF

    Article summary

    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.
    Sharing SQL Spreads Excel Document 7.1
    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.


    Was this article helpful?