Oracle Data Redaction provides the ability to masking data, typically sensitive data in real-time like credit card, Aadhar card details etc. before displaying with application. For example, in a call center, the agent able to view sensitive data in application because of the data they getting from PROD. Those Exposition may lead to privacy regulation and the corresponding user into risk.
Oracle Advanced Security Data Redaction is on-the-fly redaction, i.e., masking of sensitive data in query results prior to display by applications, as shown in the following illustration. It enables consistent redaction of database columns across application modules accessing the same data.
Data Redaction minimizes changes because it not alter source data in internal database buffers, caches, or storage, and it preserves the original data type and formatting when transformed data is returned to the application.
Redaction approaches are put away and oversaw inside the database, and they go live quickly after being empowered. Superficially, Data Redaction, and Oracle Data Masking appear to be very comparable. In any case, there is a significant distinction in that Oracle Data Redaction does not physically change the put-away data. Accordingly, Oracle Data Redaction bolsters a subset of the changes accessible with Oracle Data Masking. The intensity of Data Redaction lives in its unrivaled exhibition, requirement inside the database bit, and the explanatory strategy conditions.
Full redaction: You redact the majority of the substance of the section data. The redacted worth that is come back to the questioning client relies upon the data sort of the segment. For instance, sections of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a clear space.
Partial redaction: You redact a bit of the section data. For instance, you can redact the majority of a Social Security number with reference marks (*), aside from the last four digits.
Regular expressions: You can utilize regular expressions in both full and partial redaction. This empowers you to redact data dependent on a quest design for the data. For instance, you can utilize regular expressions to redact explicit telephone numbers or email addresses in your data.
Random redaction: The redacted data exhibited to the questioning client shows up as randomly created qualities each time it is shown, contingent upon the data kind of the section.
