For a project we plan to do the following set-up in production:
As all the 3 servers share the same database, I want to do some restrictions, so that the front servers are accessing it i na read-only mode, i.e. the user is not db_owner. I plan to set enableModelSyncCommit to false for the front servers in order to disable the model sync - it should happen only from the cms server. My question is, is it possible to give read-only permissions to the frotn servers? Is EPiServer doing some write operations that cannot be disabled? :-)
The front-end servers are also writing to the database, and even though there isn't a lot of writing happening, it is not a supported option to run them in read-only mode.