Hi guys, I run a heavily modified version of a popular CMS on my website and have more than 2000 active members. I have just hired a freelancer to make a few changes to the site. The question is that how can I ensure that he can't copy my database and still have access for developmental purposes. I have a VPS hosting. Thanks
You should change your password every now and then to avoid someone taking inappropriate advantage of your site.
Thanks. But while they have access to the site. They can copy entire database and use all the content on a different site. I am not concerned about files because its not a custom website but more concerned about database which includes customer information and all the content.
Would it be possible for you to set up a copy of your site for development purposes and have them work on that one instead? Maybe on this development copy of the site you could keep the structure the database the same, but you could clear out all the important records, perhaps replacing these with some dummy records etc. Then perhaps they could document and prepare these changes as a mod to be done on the live site. I don't have a popular site like this, but if I did I definitely would not want a stranger working on my live site and having free access to my data. Of course there are legal agreements for protection as well, but I wouldn't rely on these alone.
I would recommend that you choose someone with high iTrader/reputation as you'll be able to trust them, and also make a copy of the files and send him that, taking away the database of users. This will mean that they can work on that and send you back the files without risking your users' information.