Pete Finnigan's Oracle security weblog

Compare Oracle Autonomous Database Security to Other on-Premise Databases

I published a blog post back in 2024 where i used PFCLScan Version 2024 to scan various databases from 11g to 23c/ai. The blog is Compare the Database Security of Oracle Database 11g, 12c, 18c, 19c, 21c and 23c/ai and....[Read More]

Posted by Pete On 25/02/26 At 09:59 AM

New PFCLScan Version 2025 Released to all Customers

We have just released a new version of PFCLScan at the end of last week. This is version 2025. PFCLScan is our database security tool for the Oracle database. There are a lot of changes and fixes to this version....[Read More]

Posted by Pete On 02/02/26 At 02:43 PM

Detecting Password Guessing in Oracle using LCOUNT

I want to briefly discuss how we might detect that an attacker is trying to guess passwords and trying to connect to an Oracle database. One simple way that I have been aware of for many years, decades even is....[Read More]

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

Happy New Year 2026, Oracle Security Training, MySQL, Anniversary

I want to wish a very happy New year for 2026 to all of our customers, web site visitors and all of our social media connections and likers and commenters. Thanks for all of your support over the years!! We....[Read More]

Posted by Pete On 13/01/26 At 12:02 PM

Do Not Put Security Checks in an Oracle BEGIN END block

PL/SQL packages can have a single BEGIN/EXCEPTION/END block as part of the package such as: create or replace package body block as procedure test is begin dbms_output.put_line('Hello from test()'); end; begin dbms_output.put_line('Hello from begin; end'); exception when others then dbms_output.put_line('BEGIN:['||sqlerrm||']')....[Read More]

Posted by Pete On 24/11/25 At 02:56 PM

Join the Oracle Security Masterclass this December in York!

Are your organisation’s Oracle databases fully secured or are you leaving the door ajar to unwanted access, data leaks or worse? If you’re responsible for managing, designing or auditing Oracle databases, then the upcoming three-day course by Pete Finnigan is....[Read More]

Posted by Pete On 11/11/25 At 10:01 AM

AI for Oracle Security

I spoke about AI and Oracle security back in February in this blog - AI and Oracle Security . I asked the question can we use AI (LLM / Generative AI) in Oracle Security and if so how? The two....[Read More]

Posted by Pete On 15/10/25 At 12:42 PM

Can we Detect Disable Trigger in the Oracle Database

If i want to create layered security in a database around something such as specific data or to protect access to a resource or perhaps control access to a privilege then we can create a security layer using standard features....[Read More]

Posted by Pete On 24/09/25 At 08:37 AM