What’s the difference between Data Masking and Redaction? Oracle Data Masking Pack is mainly used for non-production environments to mask data sets in bulk. Different types of redaction are supported and you can conceal entire data values or redact only part of the value. Sensitive display data can be redacted at runtime on live production systems with minimal disruption to running applications and without altering the actual stored data. This is done with easy to create policies and with minimal resource usage.Īccording to Oracle, this security feature prevents data columns (such as credit card numbers, Social Security numbers, and other sensitive or regulated data) from being displayed. This security feature removes sensitive information at the end user layer, before the end user sees it, but without removing or changing the data in the database. When asked if you would like to use the Credit Card on file and will show something like the following It is still a feature that must be licensed separately from Oracle Database Enterprise Edition 12c, but it goes a long way in helping with the enactment of your security policies.Īn example of data redaction is something we have all seen when ordering something online at a website you’ve used before. Data Redaction is a new feature of the Oracle Advanced Security Enterprise Option introduced with version 12c.
Enacting security policies and procedures that help remove or reduce these concerns is mandatory in today’s world. For more information about Oracle (NYSE:ORCL), visit today’s growing concerns regarding the security on BYO devices ( BYOD) such as smartphones, tablets, and laptops it is critical to ensure sensitive data is not exposed. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
ORACLE DATA REDACTION EXAMPLE FULL
To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started!ġ) The first example: FULL redaction for the SAL column:Ģ) Second example: replace the SAL column with a fake value:ģ) The third example, alter the existing policy and redact the SSN column with a regular expression (regexp) mask:
ORACLE DATA REDACTION EXAMPLE LICENSE
The use of the Data Redaction feature requires a license for the Advanced Security Option (that also covers Transparent Data Encryption). The DBMS_REDACT package is a new feature in RDBMS release 12c however it has also been made available in patchset 11.2.0.4. This document shows some examples creating Data Redaction policies using package DBMS_REDACT.
Information in this document applies to any platform. Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 Some examples of implementing Data Redaction using DBMS_REDACT
0 kommentar(er)
