Exempting users from data redaction policies

In this recipe, you will create a user and then exempt that user from Data Redaction. This user will be exempted from all redaction policies in the database.

Getting ready

Before doing this recipe, you should have completed the Creating a redaction policy when using the partial redaction recipe.

How to do it...

1. Connect to the database as a user who has a DBA role (for example, user zoran):

   $ sqlplus zoran/oracle
   

2. Create a new user (for example, vipuser) and grant him the create session privilege and select privilege on table customers in schema zoran:

   SQL> create user vipuser identified by oracle;
   
   
   SQL> grant create session to vipuser;
   
   
   SQL> grant select on zoran.customers to vipuser;
   

3. Connect as a newly created user and try to select from the zoran.customers table:

   SQL> connect vipuser/oracle
   
   
   SQL> select * from zoran.customers;
   
   
   NAME             CREDIT_CARD
   ---------------- --------------...