Three Tier Oracle Security in London ~ Paul M. Wright

(nix, oracle, java, www, cloud ) intersect (safety, security, reliability, integrity)

Three Tier Oracle Security in London ~ Paul M. Wright RSS Feed

Archive for March, 2007

Forensic techniques addressed to large data sets

More on forensics with large data sets… First of all there is the physical requirement of actually copying large disks in a short time. advertise 3.9 gigabytes per second for their high speed duplication machiner. To speed up network transfer of data using netcat pipe through tar first to make the transfer quicker. Receiving [...]

Oracle Audit Vault

Oracle Audit Vault looks like it is going to be an interesting product from an Oracle Forensics perspective from what I have read. The fact that 11g is audit on by default and said to be less performance degrading will make for more archived audit in the vault and the possibility to backtrack the [...]

Free encryption products and are good replacements for PGP disk and PGP email for outlook.

Comedy moment ~

I found out a while ago that my intended URL domain and was in fact named after a city in Macedonia. If any one from Macedonia would like to have the URL for their city you are welcome to buy it from me at cost value as I decided to fit into a [...]

Timestamp as primary key and foreign key in Oracle log aggregation

Given a central Oracle loghost which collates audit and logs from firewall, WWW, OS, DB, IDS and which accesses these logs through SQL driven EXTERNAL TABLES, TIMESTAMP becomes an effective primary and foreign key to join the relations so that actions by an individual over a network can be correlated. Interestingly the uniqueness of each [...]

dcfldd binary bit copier improvement on dd

dcfldd is an improvement on dd as it shows progress through the bit copy It also does a checksum at the end to make sure you have a perfect copy. Recommended for forensics work.

Alex’s German Oracle Security paper in English


One of the students in my class asked to see the ALTER SESSION, SQL AS DBA demo so here it is.

Forensically checking the state of objects in an Oracle database

This code can be used to check and compare the objects in your database. This would be useful to see the effects of a security patch installation and to check the integrity of database objects at the database level. See my new paper at

Oracle Passwords and OraBrute paper update

The Oracle password paper I have written for my employer NGSSoftware Ltd has been translated to Japanese and also mirrored in HTML by my publisher Don Burleson’s Rampant Techpress. The English PDF URL for the paper is and the actual OraBrute tool itself is available at Edit added 22/04/2010 This paper has moved [...]