Oracle Label Security Doesn't Work With Data Label Groups
(Doc ID 2382302.1)
Last updated on MAY 01, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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