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...
Connect to the database as
SYS
user:$ sqlplus / as sysdba
Grant the
EXEMPT ACCESS POLICY
privilege to an existing user (for example,susan
):SQL> grant EXEMPT ACCESS POLICY to susan;
Connect to the database as the user
susan
and verify that now she can access data in thehr.emp_vpd_test
table.