SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Oracle Database 12c Security Free Tutorial

Oracle Consultants Available

Oracle Database Security Tutorial for PL/SQL

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 Database 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.


Oracle Certified Master
John Watson

Dec 15 - Oracle 11g RAC R2: RAC and Grid Infrastructure for Administrators with Oracle Certified Master John Watson

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

1. Introduction   (1:20)   (click to read the Transcript)
2. Tutorial Agenda   (4:11)  
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)  

Date: Recorded Aug 28, 2013

View all videos now - Free Online Registration required

Here is a preview:

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.