Oracle Forensics
Agustus 16, 2007 — amutiaraDissection of an Oracle Attack in the Absence of Auditingby David Lichtfield
Why Oracle Forensics?
- Since the state of California passed the Database Security Breach Notification Act (SB 1386) in 2003 another 34 states have passed similar legislation with more set to follow.
- In January 2007 TJX announced they had suffered a database security breach with 45.6 million credits card details stolen – the largest known breach so far.
- In 2006 there were 335 publicized breaches in the U.S.; in 2005 there were 116 publicized breaches; between 1st January and March 31st of 2007, a 90 day period, there have been 85 breaches publicized.
- There are 0 (zero) database-specific forensic analysis and incident response tools on the market – free or commercial.
Where is the evidence?
Evidence of a compromise can be found in many places – for example
- TNS Log files
- Trace files
- Redo Logs
- Datafiles
- Metadata and statistics
- Apache logs (Oracle Application Server)
This talk specifically covers the datafiles, redo logs In the essence of time we’ll be cutting out several parts of the forensic process which you wouldn’t do in a real scenario of course!
Search for evidence related to SELECTs
To start with we’ll look at an Oracle Data Block
More detailed see here