I have a running website developed in Magento CMS and hosted in AWS EC2. I just recently hired a freelance web developer located overseas to revamp my website (design, features,etc).

I have no background in web development so pardon my basic questions. The freelancer asks for all the data of my website. I know I have to share some access but I really need guidance on what and how much to share.

  1. I asked a friend to create a login credentials to access my server using SFTP in filezilla. The freelancer can now access and download all files under var/www/magento. I thought this is enough but now the freelancer is asking for database. I am not sure how to get him this or if I even need to share him this.

  2. Should I share access to magento admin panel? How do I share the database of my website?

  3. Should I create another user in AWS IAM? If yes, what will this be used for and what is the right permission level?

Thank you so much in advance.

1 Answer 1

  1. You have already created a new SFTP account with restricted directory access, which is one of the precautions to consider.

    If you are worried about the freelancer guy tampering your database, that still can be done with only FTP access. As he can access your Magento installation directory, he can get your database credentials and use those in a PHP script to tamper database, if he really wanted to do that.

    You can keep an eye on him by checking FTP transfer log and Apache access log.

  2. About Magento admin panel, there are certain cases where it is really necessary to access admin panel to test the new code changes. In some cases, creating a different admin user with restricted permissions would also help. I think there are plugins for that.

  3. And about sharing database access, the permission level depends upon what type of work he is doing. If he want to create a new table then you need to provide him a database access with table creation permissions.

  • Thanks for the advice Nikhil. Question, how do I track FTP Transfer log and Apache access log?
    – at0120
    Jan 16, 2015 at 7:47
  • The location of logs depends upon the server configuration. Generally FTP transfer log is: /var/log/xferlog. And location of apache access log is: /var/log/apache2/access_log or it could be something like MyWebsite.com/Apache/access_log for AWS-EC2. Jan 16, 2015 at 8:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.