Topic main company in Shanghai, the client company in the field, each time the repair company software is very trouble, because there are no first-hand data, can only guess what went wrong, after the commissioner, on a business trip, to fix the problem of cycle long, have been also put forward, the company used to open a database connection to us, so that we can fix the bug, but customers have been worried about security issues, afraid of opening up will be attacked, such as
You have any solution, to ensure that customer give us open database, security can improve?

CodePudding user response:

If the database is not big, you can let the customer database backup, you in the development environment using a backup file restore their use database to test program, so relatively speaking, impact on the production database without,
Open database, account management is one of the more important, whether the VPN, or database administrator account need complex passwords to protect; Operating system patch to play good, good antivirus and firewall Settings, essentially a port to see if there is any need to change, something a lot of,