OCM 11g Preparation - Implement fine-grained access control

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 👍!

Leave a Reply

Your email address will not be published.