-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle Database 12c Security Cookbook
By :

Random redaction type is usually used for the number and date-time data types because for these data types, it is hard to make a distinction between the redacted (random) and real data. In this recipe, you will create redaction policy EMP_POL
using random redaction type on hr.employees
table, column salary, by using SQL*Plus. In the Changing redaction policy recipe, you will modify the EMP_POL
redaction policy.
To complete this recipe, you'll need:
An existing user who can view data in the HR.EMPLOYEES
sample table but doesn't have an exempt redaction policy privilege (for example, hr
)
The secmgr
user created in the Creating a redaction policy using full redaction recipe or another user who can create redaction policies (has execute on the dbms_redact
package)
Connect to the database as a user who has the SELECT
privilege on the HR.EMPLOYEES
table or the SELECT ANY TABLE
privilege (for example, hr
user):
$ sqlplus...