12c INHERIT PRIVILEGES Privilege Prevents SQL Injection in PL/SQL Code
Learn how the 12c INHERIT PRIVILEGES privilege fixes another PL/SQL security problem – SQL injection – that has existed in PL/SQL invokers rights code since Oracle 8i. Oracle Certified Master DBA John Watson will explain the problems, demonstrate the problems, demonstrate the 12c fix and provide a best practice for the 12c INHERIT PRIVILEGES privilege.
Experience with invokers rights PL/SQL code is assumed. For a review of invokers rights PL/SQL see this free SkillBuilders tutorial.
This free Oracle 12c PL/SQL tutorial is segmented into several separate lessons:
- Introduction (1:28) (click on video below) (click to read the Transcript)
- Demonstration: SQL Injection via an invokers rights PL/SQL Function and an INDEX (3:07)
- Demonstration – Preventing SQL Injection (1:16)
- ** NEW AUG 31 ** Demonstration – SQL Injection via invokers rights PL/SQL Function and a VIEW (5:14)
Date: Aug 22, 2016
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.