Information
In Oracle databases prior to version 23ai, encrypted passwords for database links are stored in the PASSWORDX column, which can be decrypted. Oracle 23ai enhances security by storing encrypted database link passwords in the SPARE1 column, making decryption significantly more difficult.
Using the latest encryption method for database link passwords reduces the risk of credential exposure. Attackers who gain access to PASSWORDX can potentially decrypt and misuse stored credentials for unauthorized access.
Solution
After upgrading to Oracle 23ai, drop and recreate the database link to ensure that passwords are encrypted using the latest method.
Impact:
If a database link password is stored using an older encryption method, it could be decrypted and exploited, posing a security risk.