Pete Finnigan's Oracle security weblog

Can local LLM AI generate the top 100 most common passwords?

I am working on a simple password audit tool for Oracle Apex and I have written a simple password cracker in PL/SQL to test if a password is found or not; i.e. is the password weak or not. To allow....[Read More]

Posted by Pete On 23/07/26 At 12:01 PM

Cluster Objects in the Oracle Database

Sometimes in forensic analysis of an Oracle database it is necessary to understand how data is stored on disk. Actually we must understand that if we were to create our own database we might start with a file that holds....[Read More]

Posted by Pete On 13/07/26 At 09:11 AM

AI Comparison for Oracle Security Code Generation

I am running a Mac Book Pro M5 with 64gb of RAM and a 2tb SSD. I wanted to use local LLMs to generate Oracle security related PL/SQL to see how good these models are at generating PL/SQL code and....[Read More]

Posted by Pete On 07/07/26 At 10:43 AM

AI

My day job is Oracle security and that covers a massive area of topics from performing security audits, helping customers secure data in their Oracle databases, forensics, building and designing audit trails and reports, secure coding in PL/SQL, encryption of....[Read More]

Posted by Pete On 06/07/26 At 12:56 PM

Forensic Analysis for records in Oracle with no Timestamp

If we have an Oracle database table with no timestamp can we still get a date/time stamp when something happened? For instance if a table has a date/time column then yes of course we can know when the records changed....[Read More]

Posted by Pete On 25/06/26 At 10:53 AM

DV_SECANALYST Analyse Database Vault Views

I have been involved with Oracle Database Vault recently with a deployment and I was asked how can someone view the database vault dictionary views when DV is installed. So, if we start with no DV enabled in our database....[Read More]

Posted by Pete On 02/06/26 At 12:49 PM

I forgot my Oracle Database Vault owner Password

Let us imagine that I have a 21c database that has Database Vault (DV) enabled and I have forgotten my Database Vault owner password. In my case C##DVO. This user as well as a backup (That I have also forgotten....[Read More]

Posted by Pete On 28/05/26 At 02:17 PM

World Password Day and Oracle Security

I am slightly late with this one as the event itself was on the 7th May 2026. The World Password Day 2026 is a day to try and highlight that passwords are weak. An article I saw on line said....[Read More]

Posted by Pete On 11/05/26 At 12:37 PM