Does OUD Work with Oracle (DB) Database that Uses a Password Storage Scheme which is not SHA-1, SSHA-1, or SHA-2 ? (Doc ID 2230310.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Goal

By default users created in OUD have their password stored as Salted SHA-1 (SSHA-1).   It was found that some OUD users authentication is successful to an Oracle 10g/11g/12c database using a globally identified account.
However, for users with a stronger password storage scheme (like SHA-2 variants of SSHA-512 or SSHA-256), the following error is returned on authentication -
ORA-01017: invalid username/password; logon denied

How to configure the database and OUD to allow for a stronger password storage scheme than SSHA-1?
 

Solution

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