Oracle Label Security Doesn't Work With Data Label Groups
(Doc ID 2382302.1)
Last updated on JANUARY 23, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 12.2 BETA1 [Release 11.2 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Querying tables protected by OLS in an Oracle Database 12c with Oracle Label Security enabled gives wrong results and user cannot see data when the group is part of the data label.
The issue can be easily reproduced:
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