Perimeter
2/22/2012
11:19 AM
Adrian Lane
Adrian Lane
Commentary
Connect Directly
RSS
E-Mail
50%
50%

Can You Delete A Database?

Data and databases keep growing, but there's a security tradeoff

When was the last time you deleted a database -- not accidentally, but on purpose? Have you ever willfully deleted a database? How about removed sensitive data from one?

Most database administrators I've spoken with have never retired the contents of a database. They may migrate the contents of the old database into a newly architected repository, but seldom have they just deleted a database. Or parsed out old data lying around that was clearly obsolete, or possibly truncated tables of sensitive data. DBA's are trained to keep data consistent and make sure the data can be recovered in case of emergency. It's there job, and there is legitimate fear of being fired if you can't produce data when it's requested.

But from a security perspective removing old data is a simple security precaution. Why do I recommend this approach? First off, you can't steal what's not there. If you deleted it from the database and only keep an encrypted tape backup, you're better off if your systems are breached. Second, it's an inexpensive security option that requires no special products and no additional purchases. And as an added bonus, shrinking a database means smaller storage requirements and less overhead on queries, both of which improve performance.

The real problem is this scares the heck out of database administrators. What happens if someone actually wants that data a year from now? Could you recover it? Do you even know who owns it to ask if you can delete it? What if it was subject to regulatory controls you're not aware of? No, it's easier just to keep the data.

And in this day and age where IT keeps more databases, and collects every tidbit of data they can, databases are growing. We collect more data and look for new ways to derive information from it. More data means more information, resulting in better decisions that hopefully provide some competitive sales advantage. Conceptually, anyway. Some firms are under strict regulatory controls to keep data for five- seven-, or even ten years. But studies show data used for analytics purposes goes "bad" -- as much as 30 percent -- after after just 18 months. For your reports that means "Garbage in, Garbage out."

But unlike garbage, bad data does not smell, so DBA's have no good incentive to get rid of it. Until you're breached, that is.

Adrian Lane is an analyst/CTO with Securosis LLC, an independent security consulting practice. Special to Dark Reading. Adrian Lane is a Security Strategist and brings over 25 years of industry experience to the Securosis team, much of it at the executive level. Adrian specializes in database security, data security, and secure software development. With experience at Ingres, Oracle, and ... View Full Bio

Comment  | 
Print  | 
More Insights
Register for Dark Reading Newsletters
Partner Perspectives
What's This?
In a digital world inundated with advanced security threats, Intel Security seeks to transform how we live and work to keep our information secure. Through hardware and software development, Intel Security delivers robust solutions that integrate security into every layer of every digital device. In combining the security expertise of McAfee with the innovation, performance, and trust of Intel, this vision becomes a reality.

As we rely on technology to enhance our everyday and business life, we must too consider the security of the intellectual property and confidential data that is housed on these devices. As we increase the number of devices we use, we increase the number of gateways and opportunity for security threats. Intel Security takes the “security connected” approach to ensure that every device is secure, and that all security solutions are seamlessly integrated.
Featured Writers
White Papers
Cartoon
Current Issue
Dark Reading's October Tech Digest
Fast data analysis can stymie attacks and strengthen enterprise security. Does your team have the data smarts?
Flash Poll
Title Partner’s Role in Perimeter Security
Title Partner’s Role in Perimeter Security
Considering how prevalent third-party attacks are, we need to ask hard questions about how partners and suppliers are safeguarding systems and data.
Video
Slideshows
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2012-5242
Published: 2014-10-21
Directory traversal vulnerability in functions/suggest.php in Banana Dance B.2.6 and earlier allows remote attackers to include and execute arbitrary local files via a .. (dot dot) in the name parameter in a get_template action.

CVE-2012-5243
Published: 2014-10-21
functions/suggest.php in Banana Dance B.2.6 and earlier allows remote attackers to read arbitrary database information via a crafted request.

CVE-2012-5702
Published: 2014-10-21
Multiple cross-site scripting (XSS) vulnerabilities in dotProject before 2.1.7 allow remote attackers to inject arbitrary web script or HTML via the (1) callback parameter in a color_selector action, (2) field parameter in a date_format action, or (3) company_name parameter in an addedit action to i...

CVE-2013-7406
Published: 2014-10-21
SQL injection vulnerability in the MRBS module for Drupal allows remote attackers to execute arbitrary SQL commands via unspecified vectors.

CVE-2014-2531
Published: 2014-10-21
SQL injection vulnerability in xhr.php in InterWorx Web Control Panel (aka InterWorx Hosting Control Panel and InterWorx-CP) before 5.0.14 build 577 allows remote authenticated users to execute arbitrary SQL commands via the i parameter in a search action to the (1) NodeWorx , (2) SiteWorx, or (3) R...

Best of the Web
Dark Reading Radio
Archived Dark Reading Radio
Follow Dark Reading editors into the field as they talk with noted experts from the security world.