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
COVID-19: Latest Security News & Commentary
Dark Reading Staff 6/5/2020
Abandoned Apps May Pose Security Risk to Mobile Devices
Robert Lemos, Contributing Writer,  5/29/2020
How AI and Automation Can Help Bridge the Cybersecurity Talent Gap
Peter Barker, Chief Product Officer at ForgeRock,  6/1/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon Contest
Write a Caption, Win a Starbucks Card! Click Here
Latest Comment: What? IT said I needed virus protection!
Current Issue
How Cybersecurity Incident Response Programs Work (and Why Some Don't)
This Tech Digest takes a look at the vital role cybersecurity incident response (IR) plays in managing cyber-risk within organizations. Download the Tech Digest today to find out how well-planned IR programs can detect intrusions, contain breaches, and help an organization restore normal operations.
Flash Poll
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2020-12848
PUBLISHED: 2020-06-05
In Pydio Cells 2.0.4, once an authenticated user shares a file selecting the create a public link option, a hidden shared user account is created in the backend with a random username. An anonymous user that obtains a valid public link can get the associated hidden account username and password and ...
CVE-2020-12849
PUBLISHED: 2020-06-05
Pydio Cells 2.0.4 allows any user to upload a profile image to the web application, including standard and shared user roles. These profile pictures can later be accessed directly with the generated URL by any unauthenticated or authenticated user.
CVE-2020-13842
PUBLISHED: 2020-06-05
An issue was discovered on LG mobile devices with Android OS 7.2, 8.0, 8.1, 9, and 10 (MTK chipsets). A dangerous AT command was made available even though it is unused. The LG ID is LVE-SMP-200010 (June 2020).
CVE-2020-13843
PUBLISHED: 2020-06-05
An issue was discovered on LG mobile devices with Android OS software before 2020-06-01. Local users can cause a denial of service because checking of the userdata partition is mishandled. The LG ID is LVE-SMP-200014 (June 2020).
CVE-2020-13839
PUBLISHED: 2020-06-05
An issue was discovered on LG mobile devices with Android OS 7.2, 8.0, 8.1, 9, and 10 (MTK chipsets). Code execution can occur via a custom AT command handler buffer overflow. The LG ID is LVE-SMP-200007 (June 2020).