# Oracle E-Business Suite Account Password Decryption Threat Explored

- URL: https://www.integrigy.com/security-resources/oracle-e-business-suite-account-password-decryption-threat-explored
- Published: 2013-05-24
- Type: Webinar
- Products: Oracle E-Business Suite
- Focus areas: Vulnerabilities, Authentication
- Audience: Auditor, DBA, IT Security
- Applies to: EBS 11i, EBS 12.0, EBS 12.1
- PDF: https://www.integrigy.com/sites/default/files/Integrigy%20Oracle%20EBS%20Account%20Password%20Decryption%20Threat%20Explored%20v1.pdf
- Recording: https://www.youtube.com/watch?v=VLstXsO7xtk

> Webinar in the Hidden Security Threats series on how Oracle E-Business Suite end-user passwords can be decrypted and used to bypass application controls, how easily it is exploited, and the steps to fix it.

Oracle E-Business Suite encrypts application passwords by default instead of hashing them, so anyone who can read the `FND_USER` table, even in a test or development clone of production, can decrypt the APPS password and every end-user password with published SQL, then log in to production as any user and bypass application controls. The weakness can be fixed in most implementations.

Continuing our Hidden Security Threats in Oracle E-Business Suite series, after [Sensitive Administrative Pages in Oracle E-Business Suite](https://www.integrigy.com/security-resources/sensitive-administrative-pages-oracle-ebs-threat), we demonstrate how easily it can be exploited and the steps required to fix it. DBAs and auditors can then check that hashing is enabled and secure their clones.

## Key Points

- `FND_USER` stores the APPS password in `ENCRYPTED_FOUNDATION_PASSWORD`, encrypted with the user name and password, and each user's password in `ENCRYPTED_USER_PASSWORD`, encrypted with the APPS password, so the GUEST credentials from `fnd_web_sec.get_guest_username_pwd` decrypt APPS, and APPS decrypts every user's password, through the `decrypt` method of the Java class `oracle.apps.fnd.security.WebSessionManagerProc`.
- Encrypted passwords are cloned from production to test and development, where a programmer can read and decrypt them, so change all application user passwords, and all other environment credentials, during every clone, with forgot password functionality enabled for access.
- Hashing, introduced in 11.5.10 RUP6 and 12.0.4 but not enabled by default in any release (including 12.1), drops the encrypted APPS password from `FND_USER` and stores user passwords as one-way SHA1 hashes; on 11i, now desupported, it required upgrading every client/server program, such as Application Desktop Integrator (ADI), Oracle Discoverer and Oracle Configurator.
- DBAs enabled hashing with `FNDCPASS USERMIGRATE` (MOS ID 457166.1), verifying it for all users (MOS ID 1084956.1); as our later webinar [New Oracle E-Business Suite Security Features You Can Use Now](https://www.integrigy.com/security-resources/new-oracle-e-business-suite-security-features-you-can-use-now) covers, it is now enabled with `AFPASSWD`, not `FNDCPASS`, using SHA512 on 12.1.3+ and 12.2.3+ with patch 26175708.
- Enable strong application password controls in every EBS environment, since the hashes can still be brute forced, or use Single Sign-On (SSO) through Oracle Access Manager, so passwords are not stored in EBS (MOS ID 1388152.1).
- `FND_ORACLE_USERID` stores the passwords of all registered EBS schema database accounts, such as GL, encrypted with the APPS password, so also change all database passwords when cloning from production to test and development, using the `FNDCPASS` `ALLORACLE` option.
