I need certain users of my solution to have read-only access to the solution and database. I currently use a database filter onSolutionOpen to filter the database. Is there something similar to this that would allow me to make certain tables read only based on what group the users belongs to?
thanks!
When viewing the Table in Servoy (Under Resources=>Database Servers=>{server name}), when you double click on a table and you can see the column names, at the bottom you’ll see a tab for Security. Click that and you can set explicit table settings for different groups.
You can also do this programmatically onSolutionOpen using security.setSecuritySettings(…)