Appreciation of Oracle Security

Course description

This course is a one day seminar that gives the delegates an appreciation of what is involved in securing the Oracle database platform and also securing data in an Oracle database. The class starts the day with the basics; what is security and what is data security? We go on to discuss why your data leaks and is insecure before examining some sample exploits and techniques used by attackers. What are the basics of Oracle security; good design, data domains, data security and user security. We continue with a discussion on secure coding as well as audit trail design and how to deal with an incident or forensic analysis. We complete the day with looking at policy creation, tools and options available as well as defining a strategy.

Course goals

The aim of the class is for students to get an appreciation of where the risks lie in processing and use
of data in their organisations Oracle databases. The goal is to lay out all of the major areas of issue
and also possible solutions. The students will cover:

  • How data is stolen and stored weakly in an Oracle database
  • How to plan for data security and to develop and create a data security policy
  • How to focus your efforts on securing the right data using the right solutions

Course Pre-Requisites

The class is intended for DBAs, developers, security professionals, IT management and anyone involved in deploying, developing and maintaining Oracle databases. No detailed technical knowledge of Oracle databases is necessary in advance.

Course Material

The student will receive a URL to download a zip file that includes:

  • The course notes as PDF files
  • Free PL/SQL tools and scripts
  • All of the examples used as SQL and PL/SQL scripts

Course Outline

This course is fast-paced and very interesting and is delivered by one of the most well-known experts in database security.


  • What is Oracle Security?
  • What is data security?
  • Threats, risks, counter measures.
  • Pro-Active or Reactive?

Data Loss and Attacks

  • How does Oracle process your data?
  • What are the data issues that affect Security?
  • How do your decisions make your data insecure?
  • How do people attack your database and data?

The Basics

  • Design security, don’t make it up!
  • Data domains.
  • Data security.
  • User security.
  • Context based security.

Secure Coding

  • What is SQL Injection?
  • What other types of code attacks are there?
  • Secure coding techniques.

Design Audit Trails

  • Designing Audit Trails.
  • I want to know!
  • Options available.
  • Management.
  • Reporting and alerts.

Attacks and Forensics

  • Incident response approach and possible tools to use.
  • Where to find evidence?
  • What if I have no audit?
  • What to do next?

Choosing The Right Approach to Secure Your Databases

  • Creation of a Policy.
  • The security features of the Oracle database.
  • Additional cost options.
  • Third party options and products.
  • What if you do not license features?

Finishing Up

  • The journey today.
  • Automated testing and where to learn more.

About the instructor

Pete Finnigan created the SANS Oracle security step-by-step guide and the CIS Oracle benchmark used by NIST, USA DoD and more is a reference to secure Oracle databases. Pete worked out the mechanisms that Oracle used to protect PL/SQL and showed how they can be easily defeated at the Black Hat conference in Las Vegas in 2006. Pete has published multiple books on databases security and speaks and publishes papers regularly. His company also produces the tool PFCLScan used to protect Oracle databases.


The class is one day, 12.30 to 20.00 pm and is instructor lead with some demonstrations.


Promennt, Skeifan 11b, 108 Reykjavík


The price for the course is ISK 89,500 (roughly €720). If you also want to attend the “Hardening and Securing Oracle” course the price for both is ISK 159,500 (roughly €1290).

This price includes the fee for the course, refreshments during breaks as well as the course material.

Register for Appreciation of Oracle security or register for this course and Hardening and securing Oracle.