I am working on database security and with using Drupal we have daily backups from a cloud server which we access remotely. What I normally do is grab a daily DB copy from the cloud server, move the file over unto my local machine, and create a local copy that I can freely work on (to mess up or fix) how I choose.
However as the company grows and more people start to work on this project, having every individual have a local copy of a DB on their machine when it contains proprietary data is a huge security risk.
Is there a way for me to import a local copy of the DB to use, without actually having a physical copy on my machine? Or would this be inevitable?
Edit: For whoever down voted this, can you at least list why so I could fix it? I am trying to get genuine answers. Not have this post deleted because you think it didn't fit the right format.