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.
Course Features
- Lectures 7
- Quizzes 0
- Duration 50 minutes
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
-
Tutorials
- New Oracle PL/SQL Security Features Lesson 1
- New Oracle PL/SQL Security Features Lesson 2
- New Oracle PL/SQL Security Features Lesson 3
- New Oracle PL/SQL Security Features Lesson 4
- New Oracle PL/SQL Security Features Lesson 5
- New Oracle PL/SQL Security Features Lesson 6
- New Oracle PL/SQL Security Features Lesson 7
