Issue With Uppercase Names In The UserStorageImplementor Class (Doc ID 729886.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

The class UserStorageImplementor seems to have the following issue. Uppercase usernames in variables can suddenly be transformed to lowercase usernames. Due to this the SQL query that fetches the roles from the usersecurityattributes table does not work correctly. The query returns 0 rows although the user has roles assigned. Therefore, the user only has the guest role in the admin applets.

Here is an example of what the System Audit Information may show when the user is T111145:

userstorage 02.12 15:48:00.643 IdcServerThread-156 Start user storage query for user T111145.
userstorage 02.12 15:48:00.643 IdcServerThread-156 Expired=true isNewUser=false for t111145

As a result a little further down you will notice that the user is given the guest role:                        userstorage 02.12 15:48:00.654 IdcServerThread-156 Database->Roles=guest Accounts=#none(R),xxxxxx/(R) for t111145

Changes

Cause

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