It is possible to run the tool in the "mixed mode". In this mode, the connection settings are stored in .ini file in the program installation folder, which is usually in "Program Files" and it's not writable without having the administrator privilegdes. Thus the user will not be able to modify these settings. The rest of the settings like positions of windows, user queries, etc. will be stored inside the user local AppData folder or in the Registry.
To turn the tool into this mode do the following:
- Prepare your database connections in the tool as usual (turn the Read-only mode on if needed)
- Switch the program settings storage to the Local AppData folder using the main menu - Settings - "Settings storage location..." dialog and close the tool.
- Find the "FlySpeed SQL Query.ini" file in the "%USERPROFILE%\AppData\Local\ActiveDBSoft\FlySpeed SQL Query" folder and copy it to the program installation folder.
After that when the user will change connection properties, he will be prompted to elevate his rights to Administrator via UAC.