Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "A great example of information leakage!"] [Next entry: "A nice paper on latch internals"]

Useful PL/SQL function that returns an MD5 sum for a string

I have been a subscriber on the DBA-Village newsletter for quite a few years now and every Sunday night I get an email that lists at the top some useful links, a pole and all of the threads on the forum since the last email. DBA-Village is quite a useful site but to view the content you must register. - (broken link) The registration is free.

There was a useful link this week to a short PL/SQL function that can be used to return the MD5 sum of a string. Running a checksum of any data held in the database that is critical can be a useful thing to do. Also check summing the data dictionary or just the PL/SQL held there can also be a useful task to ensure that the dictionary has not been altered by a hacker for his own purposes.

The page on DBA-Village is titled - (broken link) Returning MD5 hash, the function is clean and simple.