You could design all layouts in FileMaker that show data form the MS-SQL data source to be read only.
Thank you but I need a more secure solution.
If all layouts are read only, it should be quite secure. And you can also set up privilege sets for different accounts such that users can only access the read only layouts.
Thank you again.
But we definitely need to be able to set a user in MS-SQL to read/only. So new dev. and research will be secured. No need to restaure BD because we may have changed some thing by mistake.
Anyone has done this before?