Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

Oracle Security Training, 12c, PFCLScan, Magazines, UKOUG, Oracle Security Books and Much More

It has been a few weeks since my last blog post but don't worry I am still interested to blog about Oracle 12c database security and indeed have nearly 700 pages of notes in MS Word related to 12c security research I have gathered already.

I have not blogged because I have been very busy and also been on vacation for two weeks in Calabria Italy which was very nice and hot and relaxing on the beach. I have quite a lot of news items to cover here, some have been mentioned on Twitter previously but its worth re-iterating them here:

1) I am teaching my class "How to perform a security audit of an Oracle database" in Rome, Italy with Oracle University on November 19th and 20th. If you would like to attend a public class in Rome then please have a look at Oracles registration,p_preview:N - Sorry its not a live link, there is something about Oracles links that make them break IE so please cut and paste it into your browser.

2) I am teaching my class "How to perform a security audit of an Oracle database" in Kiev, Ukraine wth ISSA on October the 16th and 17th with ISSP, based in Kiev. If you would like to attend this class then please vist their registration link.

3) I am teaching my class "How to perform a security audit of an Oracle database" online on October the 7th to 10th inclusive. The class is two days normally but for on-line we are going to do it over 4 days. The timing each day will be 2pm to 6pm UK time to allow students to join from the USA and also CET. We advertised this class a few weeks ago once on Twitter and had a lot of interest and a few registrations but there are still places available. The class costs £750 + VAT (if applicable) per student and if you book and pay for more than one place we will give you a discount on all places you book. Each student gets a free download of pdfs from the course (approx 570 pages) and also over 70 free tools/scripts.

If you are interested and want to book a place then please email me at pete at petefinnigan dot com

4) We have just updated our Oracle database security scanner PFCLScan to version 1.2 and released to clients. This is a reasonable size update with Oracle security specific changes and additions and also some core product changes to make it better for customers to customise and automate. We have made changes to add the first tranche of changes to support Oracle 12c and we have updated the password cracker to make its logic faster, we have re-implemented the encryption used to protect credentials and we have added the ability to create "plug-ins" for PFCLScan using PFCLScan projects and policies themselves. There are around 40 individual changes, new features, bug fixes and changes and additions to the standard policies. Please talk to us if you are interested in licensing PFCLScan

5) The other major change we have made with PFCLScan is to introduce a new license. We have a great license model for PFCLScan where the license is an annual model and based on the number of installations of the software and not the number of databases or targets that you scan. We believe that this is a fairer model and our customers seem happy with this. We had two PFCLScan licenses "Pro" and "Enterprise" that allows a single installation or as many installations as you wish on your site for the "Enterprise" license. We also offer great renewal deals, if you renew your license after one year then the renewal is 54% of the original fee.

We have a very simple license model but we have had a number of discussions with people who say there is a licence missing or a gap in our model. We have decided to rectify this. We have specifically added an engagement license so that customer can licesen PFCLScan for a 30 day period to enable a single audit engagement either internally or for a consultants customers to take place. This is again competitively priced at £85 + VAT for a single installation with a renewal for 30 more days at £70 + VAT is renewed concurrently.

6) Our second product PFCLObfuscate is also selling licenses well and is aimed at protecting Intellectual Property in PL/SQL or SQL. We have been promising to release version 2.0 for some time now. We created an alpha test version earlier this year and have tested and experimented with this. Finally we have started work to implement the production version of version 2.0. Version 2.0 is a major release and will add some great new functionallity. The core of the product is a built ibn scripting language and "hook" points that allows each piece of PL/SQL code that is parsed to be interpreted at various points (Start, Begin, End and also when any defined package call is found or when a string is found). PFCLObfuscate still obfuscates code but when a hook point is found it can decleratively execute a script to generate PL/SQL code to insert which is added and recursively obfuscated. What does all this mean?

Well it means that you can obfuscate standard package calls within your PL/SQL where you add dynamically covering APIs and also obfuscate them without adding external procedures to do this; it means that you can use any dynamic method to obfuscate strings; it means that you can insert code to execute when a string is found or a package found or when a block starts or ends. This all allows us to much more strongly protect and add license type features to PL/SQL. When combined with Wrap and WrapProtect it means that your PL/SQL code is much safer.

If anyone wants more details or would like to purchase a license then please email me.

7) I have also had two slots accepted for the UKOUG conference coming up at the start of December and this year for the first time held in Manchester. I will be chairing an open session on the 3rd of December about Oracle security so please come along and join in. My second session also on the 3rd December is going to be an hour long demo session with no slides!!, that should be really fun and exciting (spelt terror!). This talk is going to revolve around Oracle database audit trails and protections. I am going to focus on the core database and not the new 12c Unified audit and look at what works and what doesn't in terms of designing simple audit trails that are practical and can be taken away and used in your own databases. This means I am not going to focus on data auditing but on privilege audit and escalation of privilege. I am going to discuss adaptive controls, breakgalss and the aftermath of issuing a privileged password, I am going to also talk about allowing third parties into your database and capturing what they do whilst in there, I will talk about security of audit, audit of security and audit of audit. I am also going to demonstrate some simple packages that you can deploy to detect issues in the database.

I aim to cover quite a bit of ground but the goal is really to show how you can create a comprehensive audit of privilege, security and audit and cover breakglass and adaptive controls, IDS and IPS but show how its all acheivable as a good start point in your own database. Clearly there are two issues with audit, performance and storage of audit data so again I am focusing on privilege as that should not cause performance as anyone abusing privilege should not be using privilege hence if there is a performance issue the action should be stopped not the performance sorted to allow the abuse to continue. The second issue is around storage of audit trails; my solution (which can be combined with stored audit) is to act upon the trail and report on summaries and issues rather than store enourmous amounts of data.

The demo is made up of a package in PL/SQL I am calling PFCLFirewall that will implement the audit and the protections and also reports and dashboard. This is at a simple level to start with. I am going to walk through the code and explain it and then install it and abuse my database and demonstrate what it all does and how the whole thing sits together. If you come to the talk I will let you have a copy of the PL/SQL PFCLFirewall or if you ask me for it i will give it to you but after the talk of course in December. The PL/SQL package PFCLFirewall was started and the core written around a year ago but its been worked on again in between times.

8) I have also been asked to speak about Oracle security and PFCLObfuscate on Paul Dot Com on September 13th this year, so if you are interested to see this then please head over to their site and watch and listen to me speak.

9) I have also just written a new 1500 word article on Oracle 12 New Security features for the Oracle Scene magazine which will be published in time for the UKOUG conference in December in Manchester. So watch out for that.

10) I have just agreed to write some reviews of some Oracle Security products for some famous companies and I will write a nice review based on flow and practical use of a product. There will be a paper and a webcast for that later in the year. As I get more details I will let you know, so watch out for that to get a free paper and also hear me speak on a webcast.

11) Finally.... as I have now quite a lot of research on Oracle Security around Audit trails, database IDS (built in PL/SQL) discussed above, identity in the database, adaptive controls, protection of audit, security of security, breakglass and of course on 12c security i have been thinking to write to all into a nice e-book and publish on Kindle. This would be a nice book, around 150 - 190 pages and not expensive so that people can afford to buy it. It is an idea now but if i get some encouragement I will write it and publish it. A book like this may also be a good basis for a single day training class. Lets see.

OK, thats some news on Oracle security, more on 12c security next time.