Perth, Australia
+ (61) 417713124

Data Redaction New Features in Oracle 12c Release 2

  • Posted by Gavin Soorma
  • On June 27, 2017

Data Redaction was introduced in Oracle Database 12c Release 1 (read a note on this)
where we could hide or mask sensitive data in tablesĀ  from non-privileged users. The data was ‘redacted’ at query run time and was stored in the database in its normal non-redacted form. The redaction could be full (no original data displayed) or partial (some portion of the original data is returned). We could also randomly redact data or use regular expressions to look for patterns of data to redact.

A number of new features related to Data Redaction have been introduced in Oracle

We can now redact data based on different run time conditions as well as centrally manage and control data redaction policy expressions stored in the database. If we make a change to a data redaction policy expression, the change will cascade to all tables and columns which use the associated data redaction policy. Also new in 12.2, is the ability to use NULL as the redacted value.

You need to be logged in to see this part of the content. Please Login to access.


  • Sep 22 2017
Gavin, knowledge is power...I read lot of things in your blog and really admired. Now whenever i choose anything,It is asking me to register so that i would get an access.Sometimes it is frustrating too. You are a Ace Director...Do you really think your blog will make you a billionarie. Apologize if it it is harsh.. Thanks,
  • Apr 10 2020
Hey Gavin, during this tough time, I thought to utilize my time in learning new things. I really appreciate your content but a little disappointed that every time I try to read something interesting, it asks me to login and I am not a paid member. Can you make your content free at least for this month?

Leave Reply

Your email address will not be published. Required fields are marked *