Data Redaction Policy Not Applied If the Redacted Column in Included in Group By Clause
(Doc ID 2674984.1)
Last updated on MAY 28, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
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