Finding Production Data in Development Environments

Andrew Froehlich, Network Engineer & IT Consultant | 6/6/2013 | 10 comments

Andrew Froehlich
One of the biggest challenges for IT security engineers is containing sensitive data. Pinpointing where your company's PII, PHI, and PCI data resides within various production datacenters, collocations, public/private clouds, and DR environments is a major task. The difficulty increases when employees copy and move sensitive data for various purposes. Software developers are notorious for this; they sometimes take a shortcut by using production data in development environments.

Most systems development practices center on a life cycle that includes development, testing, QA, staging, and production. On enterprise networks, these stages are segregated into completely separate network and server environments. When changes or upgrades need to be made to a production application, they are validated first in one or more developer environments. It's usually during this testing period when developers borrow a copy of production data to use for testing.

If your developers are in the habit of using production data in environments other than where it is intended, it is a security issue for two reasons. First, the data could contain sensitive information about customers, partners, and employees. Because it's being copied and deployed in multiple environments, tracking this data can become nearly impossible.

The second issue is that many networks are designed to provide added layers of IT security for production environments while lessening security on others. This is because it is assumed that the data being stored and processed in these environments is not sensitive in nature. It will be easier for hackers to break into these less secure test environments and poach any production data that is being copied over there.

The solution to this problem is twofold. First, IT security admins must train developers to break their habit of using real data in environments other than production. Instead, mock or test data should be created and used for testing purposes. It might take a while longer to get clean test data, but in the end, it's well worth the extra effort. Second, production data must be locked down to the point where only a handful of trusted employees can access it. Very few people should have direct access to this data; this makes it much easier to track down if breaches occur.

Once these two simple goals are accomplished, security administrators can breathe a bit easier knowing that their production data isn't floating around in an insecure test environment.

View Comments: Newest First | Oldest First | Threaded View
Marif   Finding Production Data in Development Environments   7/1/2013 8:37:47 AM
Re: Test data
@Sara: I have also been working developers for quite a long time now and I have seen such situations when a major problem arise which get all the senior management on their toes. A single developer is working to resolve the issue and all the seniors are literally standing behind him, making the situation more miserable for him.

Another problem is the issue is not always in the specific area of the application where it raised an error which makes it even more difficult to identify. Like in a recent scenario an error occurred in the End Of Day of the system halting the whole reconciliation process and the reason was a bad transaction done during the day time.
Sara Peters   Finding Production Data in Development Environments   6/30/2013 8:43:53 PM
Re: Test data
@Marif  Ah, interesting. So often people blame developers for not generating fixes fast enough, but most people forget about the amount of time it might take to reproduce the problem that needs to be fixed. I'll be much more sympathetic to the developers I work with from now on.
Marif   Finding Production Data in Development Environments   6/26/2013 9:44:11 AM
Re: Test data
@shehan: But in case we have an error in production some times to reproduce the fault in the test environment require the production data for early fix. Otherwise I have seen some cases where developers took quite a long time to reproduce the fault.
shehan   Finding Production Data in Development Environments   6/26/2013 3:52:39 AM
Re: Test data
@Salik. Yes you are correct. Sometimes there can be instances, where the test data will not support the real software developed. It needs to plug in to the live database. Once there was an instance, where we had to use the production environment in order to test whether the data table is getting updated.
shehan   Finding Production Data in Development Environments   6/26/2013 3:06:05 AM
Re: Test data
"Instead, mock or test data should be created and used for testing purposes." Well we are point to be happy as we already practice this at our work place.
shehan   Finding Production Data in Development Environments   6/26/2013 3:04:23 AM
Re: Test data
Interesting article. We have separate test environment with the latest month end backup in order to do the developments. Once the developments are completed and tested it will be moved to the production environment.
Salik   Finding Production Data in Development Environments   6/11/2013 12:59:05 PM
Re: Test data
Good point made Andrew, this does add to the security aspect of the data. The tradeoffs would be there always, cost vs security. 
Andrew Froehlich   Finding Production Data in Development Environments   6/7/2013 2:59:27 PM
Re: Test data
@Salik and ProgMan -- if mock data isn't identical to real data then their will clearly be problems. And you are right, those bugs that are discovered later on will indeed add to costs. But everyone needs to keep in mind that security isn't free and this is one of those examples of how better security can indirectly increase the cost of other parts of the business.
User Ranking: Blogger
ProgMan   Finding Production Data in Development Environments   6/7/2013 2:54:17 PM
I suffer from this problem all the time
dealing with PHI data.  As Salik points out, there are some problems you are just never going to find using test data.  And consider that, depending on the nature of the bug, something could be put into production that introduces a system wide vulnerability where all data is compromised - simply because it was test using test data.

Is there not a middle ground here?  Something along the lines of IT Security Admins provide the subset of production data for testing purposes and then eliminate once it's finished?  
Salik   Finding Production Data in Development Environments   6/7/2013 12:48:59 AM
Test data
Great article Andrew, one thing that concerns me is the running of test cases on the test data. In my practical experience, I have noticed that running the real data on the software system after it has been tested on the test data more or less gives errors that would therefore not be identified using the test data. I mean, there are conditions that could not be found until the real data is ran on the system. Won't it just multiple the cost and effort to remove the later known bugs found after running the real data?


The blogs and comments posted on EnterpriseEfficiency.com do not reflect the views of TechWeb, EnterpriseEfficiency.com, or its sponsors. EnterpriseEfficiency.com, TechWeb, and its sponsors do not assume responsibility for any comments, claims, or opinions made by authors and bloggers. They are no substitute for your own research and should not be relied upon for trading or any other purpose.

More Blogs from Andrew Froehlich
Andrew Froehlich   4/16/2014   12 comments
With news that Google slashed the price of their big-data offering "Big Query" by up to 85 percent, one has to wonder if the move is to ward off competitors -- or simply that the ...
Andrew Froehlich   3/18/2014   26 comments
At a recent South By Southwest Interactive conference in Austin, Edward Snowden said the NSA is "setting fire to the future of the Internet." In light of this, the World Wide Web ...
Andrew Froehlich   2/28/2014   34 comments
An increasing number of partnerships, vendor contracts, and third-party agreements require opening access to your enterprise network. While offering access to these partners is usually ...
Andrew Froehlich   2/18/2014   10 comments
Annual IT security audits can be painful, yet they don't have to be.
Andrew Froehlich   2/11/2014   16 comments
Much of the focus around big data has been in electronic health records, customer data mining, and financial prediction models, but big data can be a big help in the field of IT security. ...
Latest Archived Broadcast
We talk with Bernard Golden about accelerating application delivery in the cloud.
On-demand Video with Chat
Register for this video discussion to learn how tablets can provide true business usability and productivity.
4/23/2014 - Dell Compellent performance and features make it an outstanding storage platform for SQL Server. Register for this webinar now.
E2 IT Migration Zones
IT Migration Zone - UK
Why PowerShell Is Important
Reduce the Windows 8 Footprint for VDI
Rethinking Storage Management
IT Migration Zone - FR
SQL Server : 240 To de mémoire flash pour votre data warehouse
Quand Office vient booster les revenus Cloud et Android de Microsoft
Windows Phone : Nokia veut davantage d'applications (et les utilisateurs aussi)
IT Migration Zone - DE
Cloud Computing: Warum Unternehmen trotz NSA auf die „private“ Wolke setzen sollten
Cloud Computing bleibt Wachstumsmarkt – Windows Azure ist Vorreiter
Like Us on Facebook
Twitter Feed
Enterprise Efficiency Twitter Feed
Site Moderators Wanted
Enterprise Efficiency is looking for engaged readers to moderate the message boards on this site. Engage in high-IQ conversations with IT industry leaders; earn kudos and perks. Interested? E-mail:
moderators@enterpriseefficiency.com
Dell's Efficiency Modeling Tool
The major problem facing the CIO is how to measure the effectiveness of the IT department. Learn how Dell’s Efficiency Modeling Tool gives the CIO two clear, powerful numbers: Efficiency Quotient and Impact Quotient. These numbers can be transforma¬tive not only to the department, but to the entire enterprise.

Read the full report
The State of Enterprise Efficiency in the Virtual Era: Virtualization – Smart Approaches to Maximize Gains
Virtualization is a presence in nearly all enterprise data centers. But not all companies are using it to its best effect. Learn the common characteristics of success, what barriers companies face, and how to get the most from your efforts.

Read the full report
Informed CIO: Dollars & Sense: Virtual Desktop Infrastructure
Cut through the VDI hype and get the full picture -- including ROI and the impact on your Data Center -- to make an informed decision about your virtual desktop infrastructure deployments.

Read the full report
SPONSORED BY DELL
CASE STUDIES
EBOOKS
PUBLIC SECTOR RESOURCES
VIDEOS
WHITE PAPERS
WINDOWS SERVER 2012 RESOURCES
A Video Case Study – Translational Genomics Research Institute
e2 Video


On the Case
TGen IT: Where We're Going Next

7|11|12   |   08:12   |   10 comments


Now that TGen has broken new ground in genomic research by using Dell's storage, cloud, and high-performance computing solutions, the company discusses what will come next for it and for personalized medicine.
On the Case
Better Care Through Better Communications

6|6|12   |   02:24   |   12 comments


The achievements of the TGen/Dell project could improve how all people receive healthcare, because they are creating ways to improve end-to-end communication of medical data.
On the Case
TGen IT: Where We Are Now

5|15|12   |   06:58   |   5 comments


TGen is breaking new ground in genomic research by using Dell's storage, cloud, and high-performance computing solutions.
On the Case
TGen IT: Where We Were

4|27|12   |   06:45   |   10 comments


The Translational Genomics Research Institute wanted to save lives, but its efforts were hobbled by immense computing challenges related to collecting, processing, sharing, and storing enormous amounts of data.
On the Case
1,200% Faster

4|18|12   |   02:27   |   12 comments


Through their partnership, Dell and TGen have increased the speed of TGen’s medical research by 1,200 percent.
On the Case
IT May Improve Children's Chances of Survival

4|17|12   |   02:12   |   8 comments


IT is helping medical researchers reach breakthroughs in a way and pace never seen before.
On the Case
Medical Advances in the Cloud

4|10|12   |   1:25   |   5 comments


TGen and Dell are pushing the boundaries of computing, and harnessing the power of the cloud to improve healthcare.
On the Case
TGen: Living the Mission

4|9|12   |   2:25   |   3 comments


TGen's CIO puts the organizational mission at the heart of everything the IT staff does.
On the Case
TGen Speeding Up Biomedical Research to Save More Lives

4|5|12   |   1:59   |   8 comments


The Translational Genomics Research Institute is revamping its computing to improve speed, storage, and collaboration – and, most importantly, to save lives.
On the Case
Computing Power Helping to Save Children's Lives

3|28|12   |   2:13   |   3 comments


The Translational Genomics Institute’s partnership with Dell is enabling them to treat kids with neuroblastoma more quickly and save more lives.
Tom Nolle
The Big Reason to Use Office

3|18|14   |   02:24   |   17 comments


Office and personal productivity tools come in a first-class and coach flavor set, but what makes the difference is primarily little things that most users won't encounter. What's the big issue in using something other than Office, and can you get around it?
E2 Editors
SPONSORED: Mobile Security — A Use Case

3|4|14   |   04:27   |   6 comments


New mobile security solutions can accommodate a wide array of needs, including those of a complex university environment.
Tom Nolle
Killing Net Neutrality Might Save You Money

1|16|14   |   2:13   |   11 comments


The DC Court of Appeals voided most of the Neutrality Order, and whatever it might mean for the Internet overall, it might mean better and cheaper Internet VPNs for businesses.
Tom Nolle
The Internet of Everythinguseful

1|10|14   |   2:18   |   19 comments


We really don't want an "Internet of Everything" but even building an Internet of Everythinguseful means setting some ground rules to insure there's value in the process and that costs and risks are minimized.
Tom Nolle
Maturing Google Chrome

12|30|13   |   2.18   |   25 comments


Google's Chrome OS has a lot of potential value and a lot of recent press, but it still needs something to make it more than a thin client. It needs cloud integration, it needs extended APIs via web services, and it needs to suck it up and support a hard drive.
Sara Peters
No More Cookie-Cutter IT

12|23|13   |   03.58   |   21 comments


Creating the right combination of technology, people, and processes for your IT organization is a lot like baking Christmas cookies.
Sara Peters
Smart Wigs Not a Smart Idea

12|5|13   |   3:01   |   46 comments


Sony is seeking a patent for wigs that contain computing devices.
Tom Nolle
Cloud in the Wild

12|4|13   |   02:23   |   15 comments


On a recent African trip I saw examples of the value of the cloud in developing nations, for educational and community development programs. We could build on this, but not only in developing economies, because these same programs are often under-supported even in first-world countries.
E2 Editors
SPONSORED: Is Malware Evading Your IPS?

11|18|13   |   03:16   |   4 comments


Intrusion prevention software is supposed to detect and block malware intrusions, but clever malware authors can evade your IPS in these five main ways.
Sara Peters
Where Have All the Mentors Gone?

9|27|13   |   3:15   |   38 comments


A good professional mentor can change your life for the better... but where do you find one?
Tom Nolle
SDN Wars & You Could Win

9|17|13   |   2:10   |   5 comments


VMware's debate with Cisco on SDN might finally create a fusion between an SDN view that's all about software and another that's all about network equipment. That would be good for every enterprise considering the cloud and SDN.
Ivan Schneider
The Future of the Smart Watch

9|12|13   |   3:19   |   39 comments


Wearing a bulky, oversized watch is good training for the next phase in wristwatches: the Internet-enabled, connected watch. Why the smartphone-tethered connected watch makes sense, plus Ivan demos an entirely new concept for the "smart watch."
Tom Nolle
Cutting Your Cloud Storage Costs

9|4|13   |   2:06   |   3 comments


Cloud storage costs are determined primarily by the rate at which files are changed and the possibility of concurrent access/update. If you can structure your storage use to optimize these factors you can cut costs, perhaps to zero.
Sara Peters
Do CIOs Need an IT Background?

8|29|13   |   2:11   |   23 comments


Most of the CIOs interviewed in the How to Become a CIO series did not start their careers as IT professionals. So is an IT background essential?
Ivan Schneider
The Internet Loves Birthdays

8|27|13   |   3:25   |   69 comments


The Internet has evolved into a machine for drumming up a chorus of "Happy Birthday" messages, from family, friends, friends of friends who you added on Facebook, random people that you circled on G+, and increasingly, automated bots. Enough already.