PL/SQL Secure Coding Practices
Robert Lockard, Oraclewizard.com
This is a 45 minute session that is an expansion to “Holistic Database Security” presentation that will help you secure your high performance code from sql injection attacks.We will examines common errors in pl/sql that leads to sql injection attacks. This session will define the sql injection attack vector and various ways to write code that is immune to sql injection and improve the performance of your code.-We will be covering the implementation of Code Based Access Control.-We will be covering a code architecture that separate data from code that also helps trace bottlenecks.-We will be covering Oracle PL/SQL 12C features that limit access paths to data thereby implementing part of the trusted path.-We will be covering other PL/SQL features from before 12C that help to ensure your pl/sql does what you expect it to do.- We will covering how to handle errors in your code. One of the first thing an attacker will try to generate is error messages to learn about your system. These error messages can tell the attacker what database and version you are running, and is their sql injection attack properly constructed.
Robert P. Lockard Oracle ACE Director, a professional Oracle DBA, Designer, Developer, and Project Manager. For the past twenty years he has worked as an independent consultant providing quality services to his customers at a reasonable price. He’s worked in Financial Intelligence tracking money laundering, terrorist money and identity theft. He’s also have worked in the Cyber Crimes arena tracking attacks on information systems. Robert specializes in evaluating and securing your Oracle database environment from threats both external and internal.In 1987 Robert’s boss called him into his office and told him that he is now their Oracle Wizard then handed him a stack of Oracle tapes Since then, Robert has worked exclusively as an Oracle database designer, developer and Database Administrator and project manager.Robert enjoys flying vintage aircraft, racing sailboats, photography, and technical diving. He owns and flys the “Spirit of Baltimore Hon” a restored 1948 Ryan Navion and live in Glen Burnie Maryland on Marley Creek.