4 Integrating Oracle Data Redaction with Other Oracle Products and Features
Oracle Data Redaction can be used with other Oracle products and database features.
- Oracle Data Redaction and DML and DDL Operations
Oracle Data Redaction affects DML and DDL operations, especially for users who issue SQL against tables with redacted columns. - Oracle Data Redaction and Nested Functions, Inline Views, and the WHERE Clause
Oracle Data Redaction affects nested functions, inline views, and theWHERE
clause. - Redaction Results for Queries with SQL Expressions and Set Operation When Using Columns With Redaction Policies
If a SQL expression is present in theSELECT
list of query involving columns with redaction policies, the result of the SQL expression will always be fully redacted. The redaction type specified by the user using thefunction_type
parameter will not be used to redact the data. - Oracle Data Redaction Policy and Object Transfers with Oracle Data Pump
Objects with Data Redaction policies can affect Data Pump operations. - Oracle Data Redaction and Oracle Virtual Private Database
Oracle Data Redaction does not affect Oracle Virtual Private Database policies because the VPD inline view, which contains the VPD predicate, acts on actual values. VPD column masking and data redaction policy can be applied on the same columns. VPD column masking is applied first and then the data is redacted. - Oracle Data Redaction and Oracle Database Real Application Security
The main difference between Data Redaction and Oracle Database Real Application Security is that Real Application Security is an access control technology while Data Redaction is used to limit data exposure. You shouldn't use Data Redaction as an access control solution. - Oracle Data Redaction and Oracle Database Vault
You can use Oracle Data Redaction in an Oracle Database Vault environment. - Oracle Data Redaction and Data Masking and Subsetting Pack
Oracle Enterprise Manager Data Masking and Subsetting Pack can be used to create a development or test copy of a production database. - Oracle Data Redaction and Transparent Data Encryption
Data Redaction and TDE can be used together to encrypt and limit the visibility of your data.