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...
Connect to the database as a user who has a DBA role (for example, user
zoran
):$ sqlplus zoran/oracle
Create a new user (for example,
vipuser
) and grant him thecreate session
privilege and select privilege on table customers in schemazoran
:SQL> create user vipuser identified by oracle; SQL> grant create session to vipuser; SQL> grant select on zoran.customers to vipuser;
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 ---------------- --------------...