Oracle Database 12c Security Cookbook

Exempting users from VPD policies

VPD policies are not enforced for users who connect as sysdba, during direct path export, and for users who have the EXEMPT ACCESS POLICY privilege.

Getting ready

To complete this recipe, you'll connect to the database as SYS user and grant EXEMPT ACCESS POLICY to an existing user.

How to do it...

1. Connect to the database as SYS user:

   $ sqlplus / as sysdba
   

2. Grant the EXEMPT ACCESS POLICY privilege to an existing user (for example, susan):

   SQL> grant EXEMPT ACCESS POLICY to susan;
   

3. Connect to the database as the user susan and verify that now she can access data in the hr.emp_vpd_test table.