Sign in

Pete Finnigan

@petefinnigan.bsky.social
441 followers 317 following 84 posts

Living, breathing Oracle Security; Oracle ACE on security; OAK table member. Database security audits, consulting and training on all aspects of Oracle security - www.petefinnigan.com/training/oracl…

PostsRepliesMedia
Pete Finnigan @petefinnigan.bsky.social · 23/09/2026
Can you create a simple programming language interpreter in PL/SQL and run it in the database - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepo #sym_42 #extreme #plsql #interpreter #vm #assembler #compiler #scripting #language
120
Pete Finnigan @petefinnigan.bsky.social · 16/09/2026
Can we run assembly language programs in the Oracle database? - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #plsql #interpreter #compiler #asm #assembler #vm #virtualmachine #machinecode
030
Pete Finnigan @petefinnigan.bsky.social · 10/09/2026
I have just written a blog exploring local LLMs and how they might be of use in Oracle Security - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #database #security #llm #ai #anythingllm #unsloth #rag #duckduckgo #qwen
032
Pete Finnigan @petefinnigan.bsky.social · 09/09/2026
I was asked if our scanning tools can work on old databases like 9iR2 and we created a command line version of PFCLScan to do just that - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #database #security #9ir2 #scanning #pfclscan
020
Pete Finnigan @petefinnigan.bsky.social · 07/09/2026
I was asked if Oracle synonyms can point to other synonyms; ad infinitum. I decided to test it - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #database #security #synonyms
020
Pete Finnigan @petefinnigan.bsky.social · 07/09/2026
I will be speaking at the UKOUG conference in Hammersmith In London on the 23rd and 25th November 2026. Hope to see you all there - #UKOUGDiscover2026 #UKOUG #OracleCommunity #Oracle #oracleace #oracleacepro #sym_42
020
Pete Finnigan @petefinnigan.bsky.social · 02/09/2026
A short investigation of why you cannot create the same context from two different schemas - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #database #security #context
020
Pete Finnigan @petefinnigan.bsky.social · 19/08/2026
Qwen3.8:27b is available now in Ollama so I decided to test it by generating a PL/SQL package to encrypt and decrypt data in Oracle database. Is it better than qwen2.5-coder & qwen3-coder? - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #ai #llm #qwen38 #macbook #m5 #max
030
Pete Finnigan @petefinnigan.bsky.social · 17/08/2026
I have just posted a blog about how to find what rules expressions are tied to command rules in Database Vault in Oracle - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #oracle #database #vault #dv #command #rule
030
Pete Finnigan @petefinnigan.bsky.social · 05/08/2026
I have just put out a new blog discussing improving my use of a local LLM to find a list of weak passwords - www.petefinnigan.com/weblog/archi... - #oracleace #oracleacepro #sym_42 #ai #oracle #database #security #llm #rag
020
Pete Finnigan @petefinnigan.bsky.social · 03/08/2026
As part of a forensic analysis of a breached Oracle database we can make use of date/timestamp data to help create a timeline of events - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #forensics #timeline
010
Pete Finnigan @petefinnigan.bsky.social · 03/08/2026
I just received the goodies from the Oracle Ace Program for my Oracle ACE Pro membership / recognition. Thanks to Oracle and the program - #oracleace #oracleacepro #sym_42 #oracle #database #security
151
Pete Finnigan @petefinnigan.bsky.social · 29/07/2026
Following on from my comparison of Oracle security with AI, I have taken that further to think about protecting data used in AI and auditing that data and changes to the AI itself - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ai #llm #sovereign #aisecurity
020
Pete Finnigan @petefinnigan.bsky.social · 28/07/2026
I have just released a new blog post looking at data security in AI and is it similar to Oracle security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ai #llm #oracle #database #security
020
Pete Finnigan @petefinnigan.bsky.social · 23/07/2026
I did a test with 6 local LLMs to see if i could get a list of the top 100 weakest passwords for use in an Oracle Apex Password cracker - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #ai #sovereignty #llm #local #dataprotection
030
Pete Finnigan @petefinnigan.bsky.social · 13/07/2026
What are clusters in the Oracle database and how can we find out the details of clusters in the meta data - www.petefinnigan.com/weblog/archi... -#oracleace #sym_42 #oracle #forensics #database #security #internals #clusters
020
Pete Finnigan @petefinnigan.bsky.social · 07/07/2026
I did an experiment with 3 different Large Language Models asking them to generate some PL/SQL encryption code - results here - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ai #llm #qwen3-coder #plsql #oracle #security #generate #code
030
Pete Finnigan @petefinnigan.bsky.social · 06/07/2026
I have been playing with a local LLMs on a mac. Here are some thoughts on AI and using with Oracle Security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ai #llm #localllm #oracle #security
030
Pete Finnigan @petefinnigan.bsky.social · 29/06/2026
50 years ago today; my friend Paul and I stopped an express train from crashing as we saw that an axle end had snapped off one carriage. We got the train stopped before it was going full speed so no one was hurt. It was major news and we got a medal! - #train #crash #averted
040
Pete Finnigan @petefinnigan.bsky.social · 25/06/2026
If want to forensically analyse an Oracle database and some records have no date/timestamp column; what can we do? - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #forensics #database #security #scn #hacking #databreach
020
Pete Finnigan @petefinnigan.bsky.social · 25/06/2026
If want to forensically analyse an Oracle database and some records have no date/timestamp column; what can we do? - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #forensics #database #security #scn #hacking #databreach
020
Pete Finnigan @petefinnigan.bsky.social · 03/06/2026
I have just received notice that I have been made an Oracle ACE Pro again for the period 1st June 2026 to 31st May 2027 - #oracleace #sym_42 #oracle #security
291
Pete Finnigan @petefinnigan.bsky.social · 02/06/2026
I have been investigating how views such as DBA_DV_FACTOR can be accessed when DV is enabled or not - petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #databasevault #vault #dv #dv_secanalyst
030
Pete Finnigan @petefinnigan.bsky.social · 28/05/2026
I have written a blog post investigating what I can do if I lost the DV_OWNER password in Database Vault - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #hacking #database #vault #password #lost #cracking
020
Pete Finnigan @petefinnigan.bsky.social · 11/05/2026
World Password day was a few days ago; what does it mean for Oracle databases and a simple quiz - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #world #password #day #cracking # hacking
050
Pete Finnigan @petefinnigan.bsky.social · 05/05/2026
I have just put the slides from my ukoug 2025 talk around securing data in Oracle on my website - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #lockdown #protection #data #hacking #data #databreach #readonly
020
Pete Finnigan @petefinnigan.bsky.social · 20/04/2026
I have just released the slides from my UKOUG talk last December on fuzzing PL/SQL - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #plsql #code #vulnerabilities #vulerability #hacking #fuzzing #blindtesting
050
Pete Finnigan @petefinnigan.bsky.social · 16/03/2026
PeteFinnigan.com Limited has been helping people secure data in Oracle databases for 23 years. New blog to discuss Oracle security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #lockdown #databreach
040
Pete Finnigan @petefinnigan.bsky.social · 25/02/2026
I security scanned 19c and 26ai Oracle Autonomous Databases and compared the results as well as going back and comparing to 11g to 23c/ai on premise databases - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ukoug #oracle #database #security #securityscan #vulnerabilities
051
Pete Finnigan @petefinnigan.bsky.social · 02/02/2026
New PFCLScan version 2025 has just been released - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #tools #audit #plsql #forensics #obfuscate
010
Pete Finnigan @petefinnigan.bsky.social · 15/01/2026
Can we detect if someone is guessing passwords in an Oracle database? New blog - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #password #cracking #hacking #users #connection #failed #logins
060
Pete Finnigan @petefinnigan.bsky.social · 13/01/2026
Happy New Year 2026 to all of our customers, website visitors and social media connections/followers and likers. New blog on Oracle Security training, MySQL and more - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #training #mysql
petefinnigan.com
Happy New Year 2026, Oracle Security Training, MySQL, Anniversary
Pete Finnigan's Oracle security weblog
010
Pete Finnigan @petefinnigan.bsky.social · 03/12/2025
Just got back from 2 great days at the UKOUG 2025 conference in Birmingham. Great to chat to so many people and thanks to all who attended my two talks. #oracleace #sym_42 #ukoug #ukougdiscover25
040
Pete Finnigan @petefinnigan.bsky.social · 24/11/2025
Do not put security checks in the begin/end block of a package if you want the security to work - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #checks #plsql #package
030
Pete Finnigan @petefinnigan.bsky.social · 11/11/2025
If you’re responsible for managing, designing or auditing Oracle databases, then the upcoming three-day course by Pete Finnigan is one you won’t want to miss - www.petefinnigan.com/weblog/archi... - #oracleace #OracleSecurity #DatabaseSecurity #OracleDBA #CyberSecurityTraining #OracleTraining
041
Pete Finnigan @petefinnigan.bsky.social · 03/11/2025
Are you worried that someone could steal the data from your Oracle database? Do you feel overwhelmed and need guidance to secure your database. I will be teaching 3 days in depth training in York, UK on the 3rd, 4th and 5th December 2025. lnkd.in/eniNGiQP Book your place now -
021
Pete Finnigan @petefinnigan.bsky.social · 21/10/2025
I will be teaching a 3 day Oracle Security class in York, UK from 3rd to 5th December 2025. Full details of the class are here - www.petefinnigan.com/training/ora... - Rare opportunity to be taught in person. To book early as places limited #oracle #security #training #oracleace
021
Pete Finnigan @petefinnigan.bsky.social · 15/10/2025
I have just posted a new blog discussing AI and AI for Oracle Security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ukoug #ai #UKOUGDiscover25 #OracleCommunity #JoelKallmanDay #oracle #database #AI
074
Pete Finnigan @petefinnigan.bsky.social · 24/09/2025
Brand new blog post discussing how we may block DISABLE TRIGGER to help with designing security solutions within the database - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #grants #ddl #trigger #protect #hacking #databreach #UKOUGDiscover2025
020
Pete Finnigan @petefinnigan.bsky.social · 22/09/2025
I have been accepted to speak twice at the UKOUG conference in December - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #UKOUGDiscover25 #UKOUG #conference #community #oracle #database #security #fuzzing #design #plsql
040
Pete Finnigan @petefinnigan.bsky.social · 10/09/2025
My Oracle Security blog is 21 next week. I have created a summary post detailing some of the blog journey - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #tools #software #training #products #blogging #birthday
040
Pete Finnigan @petefinnigan.bsky.social · 09/09/2025
Is it possible in Oracle to stop your own procedure/package from being executed by someone with EXECUTE ANY PROCEDURE? - petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #audit #trail #audittrail #databreach #hacking #grants #protect #readonly #table
050
Pete Finnigan @petefinnigan.bsky.social · 03/09/2025
Testing our secured schema and table to allow READONLY and delete and insert only via an API - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #audit #trail #audittrail #databreach #hacking #grants #protect #readonly #table
030
Pete Finnigan @petefinnigan.bsky.social · 26/08/2025
Lets implement an account you cannot log into and a table that you can read but not delete/insert except by an API and no updates! - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #audit #trail #audittrail #grants #protect #readonly #table
020
Pete Finnigan @petefinnigan.bsky.social · 19/08/2025
New blog discussing how we may replicate the security of the AUDSYS.AUD$UNIFIED table without access to Oracle secret sauce - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #audit #unified #protect #audittrail #databreach #readonly #grants #protection
020
Pete Finnigan @petefinnigan.bsky.social · 14/08/2025
What is a schema in Oracle and what does the CREATE SCHEMA command do? - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #create #schema
041
Pete Finnigan @petefinnigan.bsky.social · 12/08/2025
Exploring how Oracle may or may not secure AUDSYS and AUD$UNIFIED - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #security #audit #unified #protect #audittrail #databreach
040
Pete Finnigan @petefinnigan.bsky.social · 11/08/2025
Twisted foot sideways and heard loud snap so knew it was broken. Rang 111, A&E and Urgent Care, x-ray &had the boot fitted quickly. 4-6 weeks for it to heal BUT all Oracle Security work, training and products are available #oracleace #sym_42 #oracle #security #training #software
020
Pete Finnigan @petefinnigan.bsky.social · 07/08/2025
A new PL/SQL unwrapper for 9i and lower - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #plsql #unwrap #reverse #engineering #security
061
Pete Finnigan @petefinnigan.bsky.social · 05/08/2025
New blog about attacking and protecting the Oracle database from file system issues - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #database #security #dos #hacking #file #directory #java
051