A mini series about Virtual Private Database with Oracle Database 12c
This content is intended for the following job role(s): Security Compliance Auditor, Identity Administrator, Support Engineer, Security Administrator, Database Administrator
Release Date: 20-AUG-2014
Created by: Maria Billings
This video includes an optional review of the VPD policy execution, then a function is created with intentional errors for learning purposes, and you see how to diagnose, troubleshoot, and correct errors. Prerequisite video: "Using Virtual Private Database with Oracle Database 12c" which contains the setup of the test case.
Duration: 3 minutes
This video shows how the type of a VPD policy affects its execution. For learning purposes it first shows an incorrect use of a policy type, which is then corrected. Prerequisite video: "Using Virtual Private Database with Oracle Database 12c" which contains the setup of the test case. Next video: "Troubleshooting a VPD policy in Oracle Database 12c"
Duration: 5 minutes
This video shows you how to implement a security policy using the application context functionality of Oracle Database 12c. It includes: 1. What is FGAC and VPD? 2. Set up for the demo (Create user, application context, package, trigger and grant privileges). 3. Create the package that is used by the security policy to return a predicate. 4. Create a policy and test it. 5. Drop a policy. Recommended after this: * Using VPD Types * Troubleshooting a VPD policy
Release Date: 02-DEC-13