Oracle 12c Grant Role to PL/SQL Procedures
A great new security feature that can – among other things – prevent SQL injection and a multitude of other security vulnerabilities.
In 12c you can make your PL/SQL code secure using a declarative technique. Simply grant a role to the PL/SQL code and add AUTHID CURRENT_USER so that Oracle runs the code with the privileges of the invoker – not the developer (invoker rights procedures). Presto! Without code reviews and / or debugging you will have hardened your PL/SQL web application!
In this free tutorial from SkillBuilders Director of Oracle Database Services, Oracle Certified Master John Watson will demonstrate the development of a simple PL/SQL web application, demonstrate SQL injection and how to prevent it with this new feature.
- Lectures 3
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 5
- Certificate No
- Assessments Yes
Leave A Review
Please provide as much detail as you can to justify your rating and to help others.