Oracle Database applies the redaction at runtime when users access the data (that is, at query-execution time). You can use this option to test the redaction policy definitions before applying them to a production environment. The None redaction type option enables you to test the internal operation of your redaction policies, with no effect on the results of queries against tables with policies defined on them. The redacted data presented to the querying application user appears as randomly generated values each time it is displayed, depending on the data type of the column. It is designed for use with character data only. For example, you can use regular expressions to redact email addresses, which can have varying character lengths.
You can use regular expressions to look for patterns of data to redact.
For example, you can redact a Social Security number with asterisks (*), except for the last 4 digits. For example, columns of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a single space. The redacted value returned to the querying application user depends on the data type of the column. You redact all of the contents of the column data. During the time that the data is being redacted, all of the data processing is performed normally, and the back-end referential integrity constraints are preserved.ĭata redaction can help you to comply with industry regulations such as Payment Card Industry Data Security Standard (PCI DSS) and the Sarbanes-Oxley Act.You can redact column data by using one of the following methods:įull redaction. This solution works well in a production system. Oracle Database applies the redaction at runtime, when users access the data (that is, at query-execution time).
Oracle data redaction example full#
Full redaction. You redact all of the contents of the column data.You can redact column data by using one of the following methods: Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications.
0 kommentar(er)
