Is there an easy way to create a read-only role?

The way I read the documentation, the only way to on-board a new user-role with a read-only account is to create that role and then manually mark each field as read-only, one-by-one. This seems ridiculously tedious, so I'm hoping someone can tell me an easier way that I've missed.

We're in Sugar 9 now, if that matters, but planning an upgrade to 11 as soon as it launches.

Parents Reply Children
  • I sympathize @billockb there is no easy way to set them all read-only, it would be nice to be  able to do that. Perhaps you could suggest that. There used to be an "Ideas" section in the old Sugar Community  is there something similar in SugarClub?

    If you are On Site, you could probably find a way to set these at the database level by digging into the acl_* tables, but it might get tricky if not downright messy.

    You might also want to see if you can leverage some of 's work here:
    enricosimonetti.com/.../

  •  unfortunately there is no easy answer for you here.

    I will be shooting in the dark a little, trying to give you some hints.

    One relatively technical workaround would be to leverage a community tool we built called SystemData. That was built 4+ years ago, and I am not even sure it still works today, but you could give it a try. The tool can be found on this public git repository of SugarCRMLabs github.com/.../SystemData

    The aim of the tool at the time was to export/import system information across instances.

    The way you could use it is to extract the role information (which will give you a json export file). On the json file you could quickly change the permissions needed and re-import it.

    I realise this is more of an admin/developer tool, but it could help you get where you want to be faster, plus it could help you version/keep a backup of your roles definition.

    The way I would use it is on a sandbox first. Then after you verify that it installs fine, and that the export/import of manually modified roles works on a sandbox all as expected, you could proceed further.

    If you do try it, let us know how that goes!

    --

    Enrico Simonetti

    Sugar veteran (from 2007)

    www.naonis.tech


    Feel free to reach out for consulting regarding:

    • API Integration and Automation Services
    • Sugar Architecture
    • Sugar Performance Optimisation
    • Sugar Consulting, Best Practices and Technical Training
    • AWS and Sugar Technical Help
    • CTO-as-a-service
    • Solutions-as-a-service
    • and more!

    All active SugarCRM certifications

    Actively working remotely with customers based in APAC and in the United States