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 11.2.0.4 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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.