Excelent Oracle 12c PL/SQL Security Free Oracle Database Tutorial by SkillBuilders

Oracle 12c PL/SQL Security Free Oracle Database Tutorial

Historically, we had definer's rights and invoker's rights. Definer's rights code lets the invoker escalate his privileges, invoker's rights code lets the definer escalate his privileges. Big problem! And the use of roles complicated things further. We have all been caught out by misunderstanding how roles are applied (or not) within PL/SQL. Oracle 12c tidies this up, with the INHERIT [ANY] PRIVILEGE privilege, and the ability to grant roles to program units. It is enabled by default, so make sure you understand it. 

Presented by Oracle Certified Master John Watson, SkillBuilders' Director of Oracle Database Services.

This free Oracle 12c PL/SQL Security tutorial is segmented into several separate lessons:

1. Introduction   (1:20)   2. Tutorial Agenda   (4:11)   (click to read the Transcript) 3. Review: Definer and Invoker's Rights (We'd bet you didn't know all this.)   (16:51)   4. Review: Roles and PL/SQL   (6:21)   5. 12c INHERIT PRIVILEGES Privilege   (6:47)   6. 12c Granting Roles to Procedures   (6:37)   7. 12c Bequeath Views   (1:44)   8. 12c PL/SQL Security Summary   (3:57)