Before studying this topic, I would recommend you to study the Create and manage contexts as VPD can be used together with Contexts and they both mix very well.
This is yet another topic that is impossible to do fast in the exam, if requested, without using the official documentation. So, be prepared to access it. The docs has 3 tutorials that are very, very good. So be prepared to use and adapt them.
Also, I recommend you to have knowledge in the policy views:
- (ALL/DBA/USER)_POLICIES
- (ALL/DBA/USER)_POLICY_CONTEXTS
- (ALL/DBA/USER)_POLICY_GROUPS
- (ALL/DBA/USER)_SEC_RELEVANT_COLS
- V$VPD_POLICY
Path to Documentation:
Database Security Guide -> 7 Using Oracle Virtual Private Database to Control Data Access
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!