Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Perimeter

12/22/2008
03:14 PM
John H. Sawyer
John H. Sawyer
Commentary
50%
50%

Database Breach Preparedness

A copy of "SQL Server Forensic Analysis," by Kevvie Fowler, arrived in my mailbox today. I'd been looking forward it to because it is a highly topical subject given all of the data breaches that have occurred in the past couple of years involving databases. David Litchfield has produced numerous whitepapers and presented on the topic of Orac

A copy of "SQL Server Forensic Analysis," by Kevvie Fowler, arrived in my mailbox today. I'd been looking forward it to because it is a highly topical subject given all of the data breaches that have occurred in the past couple of years involving databases. David Litchfield has produced numerous whitepapers and presented on the topic of Oracle forensics, but little has been published on forensics of Windows SQL Server systems.In fact, if you take a look at databasesecurity.com, there are more than a dozen forensics articles about Oracle systems and one on SQL Server, which just happens to be Fowler's presentation from Black Hat USA 2007. I have a question for you CSOs and security team managers: How many of you have forensic investigators on your staff with extensive database skills?

I have a feeling the answer to that is going to be a very small number. Depending on your state laws regarding breach disclosure and your company policy, just knowing that an attacker had the ability to access the database is enough of a reason to notify individuals who had personal data on the system. The flip side of the coin is that even if the attacker could have accessed the database, did he/she and what specific data was accessed?

The last scenario is where database forensics becomes important, but most investigations end there due to lack of expertise. However, after spending an hour reading through several of the chapters, I'm convinced that if you were take the time to read this book, set up the example database, create a SQL Server incident response toolkit, configure your forensic workstation for analysis of a SQL Server, and work with the included incident response scripts, you would be prepared to take on a forensic case involving an MS SQL Server.

It goes without saying that databases are the crown jewels for many organizations. Being able to adequately respond to incidents involving them is crucial as we move forward with targeted attacks focusing on monetary gain and corporate espionage. If your team is not ready to handle a case involving a database, then it's time to add that skill set to your arsenal.

For MS SQL Server environments, take a good look at Fowler's book. For Oracle shops, David Litchfield's seven-part Oracle Forensics series is available at databasesecurity.com, along with papers from other authors. Litchfield also has an upcoming book titled "Oracle Forensics Using Quisix," so be on the lookout for it.

John H. Sawyer is a Senior Security Engineer on the IT Security Team at the University of Florida. The views and opinions expressed in this blog are his own and do not represent the views and opinions of the UF IT Security Team or the University of Florida. When John's not fighting flaming, malware-infested machines or performing autopsies on blitzed boxes, he can usually be found hanging with his family, bouncing a baby on one knee and balancing a laptop on the other. Special to Dark Reading.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
News
FluBot Malware's Rapid Spread May Soon Hit US Phones
Kelly Sheridan, Staff Editor, Dark Reading,  4/28/2021
Slideshows
7 Modern-Day Cybersecurity Realities
Steve Zurier, Contributing Writer,  4/30/2021
Commentary
How to Secure Employees' Home Wi-Fi Networks
Bert Kashyap, CEO and Co-Founder at SecureW2,  4/28/2021
Register for Dark Reading Newsletters
White Papers
Video
Cartoon Contest
Current Issue
2021 Top Enterprise IT Trends
We've identified the key trends that are poised to impact the IT landscape in 2021. Find out why they're important and how they will affect you today!
Flash Poll
How Enterprises are Developing Secure Applications
How Enterprises are Developing Secure Applications
Recent breaches of third-party apps are driving many organizations to think harder about the security of their off-the-shelf software as they continue to move left in secure software development practices.
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2021-31755
PUBLISHED: 2021-05-07
An issue was discovered on Tenda AC11 devices with firmware through 02.03.01.104_CN. A stack buffer overflow vulnerability in /goform/setmac allows attackers to execute arbitrary code on the system via a crafted post request.
CVE-2021-31756
PUBLISHED: 2021-05-07
An issue was discovered on Tenda AC11 devices with firmware through 02.03.01.104_CN. A stack buffer overflow vulnerability in /gofrom/setwanType allows attackers to execute arbitrary code on the system via a crafted post request. This occurs when input vector controlled by malicious attack get copie...
CVE-2021-31757
PUBLISHED: 2021-05-07
An issue was discovered on Tenda AC11 devices with firmware through 02.03.01.104_CN. A stack buffer overflow vulnerability in /goform/setVLAN allows attackers to execute arbitrary code on the system via a crafted post request.
CVE-2021-31758
PUBLISHED: 2021-05-07
An issue was discovered on Tenda AC11 devices with firmware through 02.03.01.104_CN. A stack buffer overflow vulnerability in /goform/setportList allows attackers to execute arbitrary code on the system via a crafted post request.
CVE-2021-31458
PUBLISHED: 2021-05-07
This vulnerability allows remote attackers to execute arbitrary code on affected installations of Foxit Reader 10.1.1.37576. User interaction is required to exploit this vulnerability in that the target must visit a malicious page or open a malicious file. The specific flaw exists within the handlin...