My Oracle Support Banner

Data Security Not Working When User Id Length >30 (Doc ID 2851384.1)

Last updated on JANUARY 11, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

 Certain users with application user ID length greater than 30, are able to access RMS data without being granted any data access through the Security Users template upload.

Steps To Reproduce:

Pre-requisite: Enable Data security (data_level_security_ind='Y' in SECURITY_CONFIG_OPTIONS) and ensure no security setup is done for the users in SEC_USER /SEC_USER_GROUP.

  1. Setup Application users, such that there are users with length >30 characters.
  2. Login to MFCS and validate data access.

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
References


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