Introduction

Oracle Data Redaction is a new security feature, introduced in Oracle Database 12c. From a licensing viewpoint, it is part of the Advanced Security Option (only available as an option for Oracle Database Enterprise Edition). However, afterwards, Oracle decided to make it available in Oracle Database 11g as well (only in version 11.2.0.4). The main idea behind this feature is to mask (hide/redact) some (sensitive) data from end-users. Having this in mind, it is logical that you will primarily use this security solution in a production environment.

Note

Oracle Data Redaction and Oracle Data Masking are both used to mask sensitive data, but these solutions are completely different—from the way they are designed (how they work) to their target implementation use cases. Oracle Data Masking enables organizations to use production data in development and test environments by changing production data with realistic data (transformation is done by using masking rules).

Oracle...