Pete Finnigan's Oracle security weblog

Oracle Security AnythingLLM Tools

As you will have noticed in my blogs I have been using and playing with AI and Large Language Models (LLMs) for a while now but with a focus on Oracle Security still. I want to understand the capabilities of....[Read More]

Posted by Pete On 10/09/26 At 10:35 AM

Perform a Security Audit of an Old Oracle Database

We support doing security audits of all of the current Oracle databases from 19c to 21c and 26ai. We also support doing security audits on databases in your own data center or in the cloud. No matter where the database....[Read More]

Posted by Pete On 09/09/26 At 12:33 PM

Can Synonyms Point to Synonyms?

I got asked a question via a DM on one of my social media channels a few days ago and thought it worth an investigation. They asked me; Can an Oracle synonym point to another synonym, ad infinitum. Let me....[Read More]

Posted by Pete On 07/09/26 At 08:08 AM

Contexts are Database Level Objects in Oracle

I was asked by someone recently why their context values had disappeared. They had two database users that created the same context. Yes, I know you cannot do that but there was a subtle reason that the code did not....[Read More]

Posted by Pete On 02/09/26 At 09:30 AM

Using Qwen3.8:27b to create a PL/SQL encrypt/decrypt Package

A few weeks ago I did a sample blog post to use local LLM to create a PL/SQL package to encrypt and decrypt data in an Oracle database - AI Comparison for Oracle Security Code Generation . In that blog....[Read More]

Posted by Pete On 19/08/26 At 12:42 PM

Find rules for a Command Rule in Database Vault

There are many components that are part of Database Vault. At the lowest level are factors that encapsulate the individual pieces of data that you may use in the rest of the set up. Then there are DV rules that....[Read More]

Posted by Pete On 17/08/26 At 12:51 PM

Testing a Better System Prompt

I am using my local LLM using a mac book pro M5 64gb and running Ollama, open-webui via docker and the interface on my Windows laptop. I posted a blog recently Can local LLM AI generate the top 100 most....[Read More]

Posted by Pete On 05/08/26 At 09:35 AM

Oracle Forensics - Dates and Times in USER$

As part of a previous investigation when looking at timestamps and dates for changes recorded to the database meta data I noticed in addition to the normal columns the SYS.USER$.SPARE6 column as it was populated for some users. I also....[Read More]

Posted by Pete On 03/08/26 At 01:59 PM