Data Redaction Policy Not Applied If the Redacted Column in Included in Group By Clause
(Doc ID 2674984.1)
Last updated on AUGUST 08, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
If a TDE encrypted column is redacted,then the policy is not applied when the column in included in the "group by" clause in a SQL query.
Redacted columns should never be included in the "group by" clause.
If included,"ORA-00979: not a GROUP BY expression" should be raised.
In this case,the error is not raised and just the redaction policy does not take effect.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |