Oracle does not support this, and raises an error: ORA-01791: not a SELECTed expression. This happens because internally the expression in the SELECT list must be modified by Data Redaction, but this causes it to no longer be found when it comes time to process the GROUP BY clause (which is currently not updated by Data Redaction) leading to this unintended error message.ĭo not include any redacted columns in a SQL expression that is used in both the DISTINCT clause and ORDER BY clause in a SQL statement. Oracle does not support this, and raises an ORA-00979: not a GROUP BY expression error.
You can use JavaScript Object Notation (JSON) on redacted data.ĭo not include any redacted columns in a SQL expression that is used in a GROUP BY clause in a SQL statement. 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 Data Masking and Subsetting Pack.Oracle Data Pump export operations can affect objects that have Oracle Data Redaction policies. Oracle Data Redaction and Oracle Data Pump.
You can use Oracle Data Redaction in an Oracle Database Vault environment.
Oracle Data Redaction and Oracle Database Vault. Oracle Data Redaction differs from Oracle Database Real Application Security because of how security is implemented for applications. Oracle Data Redaction and Oracle Database Real Application Security. 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. Oracle Data Redaction and Oracle Virtual Private Database. You cannot use XML generation functions on columns that have Oracle Data Redaction policies defined on them. Oracle Data Redaction and XML Generation. You can use object types to model real-world entities such as customer accounts. Oracle Data Redaction and Aggregate FunctionsĪggregate functions can affect performance overhead on Oracle Data Redaction policies. Oracle Data Redaction and Database Linksĭo not create Oracle Data Redaction policies on database views that reference database links. Queries that include the DISTINCT or ORDER BY clause on columns that are protected by Oracle Data Redaction policies may return 0 rows. Oracle Data Redaction and Queries on Columns Protected by Data Redaction Policies. You can use Oracle Data Redaction with nested functions, inline views, and the WHERE clause in SELECT statements. Oracle Data Redaction and Nested Functions, Inline Views, and the WHERE Clause. Oracle Data Redaction affects DML and DDL operations, especially for users who issue ad-hoc SQL against tables with redacted columns. Oracle Data Redaction and DML and DDL Operations. It is important to understand usage guidelines for using Oracle Data Redaction. Oracle Data Redaction General Usage Guidelines.
0 kommentar(er)
