Pete Finnigan's Oracle security weblog

Extreme PL/SQL - Creating your a simple programming interpreter language in PL/SQL

Last week I posted a blog - Extreme PL/SQL - Running an Assembly Language Program in PL/SQL where I presented the fact that I have written a virtual machine on PL/SQL and also an assembler in PL/SQL and showed how....[Read More]

Posted by Pete On 23/09/26 At 07:52 AM

Extreme PL/SQL - Running an Assembly Language Program in PL/SQL

Back in 2022 I started work on an idea that I could build an interpreter for a simple language in PL/SQL and then building on that create a Virtual Machine in PL/SQL and an assembler in PL/SQL for the assembly....[Read More]

Posted by Pete On 16/09/26 At 08:54 AM

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