Already, any user that can run WinSQL* from their PC can change any data they access with SQL commands (update, delete, insert). I would like to prevent this to avoid any disaster.
The WINSQL package is not limited by our green screen application, so it can directly access the database and change data which can be a disaster.
There are two possible options to prevent problems:
- Implement true security architecture and define correct authorities to the files in the data base. This is the "correct" solution but it is difficult and sometime not practical to implement.
- Install a security software package to monitor and control remote access to your data base (or write your own exit program). Example products are firewall++ from Raz-Lee or network security by Powertech.
This was first published in July 2009