Find APPS and SYSADMIN passwords

Find APPS Schema Password

1) Connect as SYSDBA at Database tier

sqlplus '/as sysdba'

2) Create Function to decrypt the encrypted password

SQL> create or replace FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String)
return java.lang.String';
/

3) Query for Apps password

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD
----------------------------------------------------------------------------------------------------
ZH0F65A2809A180704C3A80305DABCCD29B70970150B7547081AE06D619BC08230D59734F23261F6A1C734D7B1C60F8A4E70

Then

 SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZH0F65A2809A180704C3A80305DABCCD29B70970150B7547081AE06D619BC08230D59734F23261F6A1C734D7B1C60F8A4E70') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZH0F65A2809A180704C3A80305DABCCD29B7097015
--------------------------------------------------------------------------------
THAGIDATHAGIDA

Find SYSDAMIN or any Front-End user Password

1) Connect as APPS user

sqlplus apps/thagidathagida

2) Create the decrypt package

CREATE OR REPLACE PACKAGE XXX_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXX_GET_PWD;
/

3) Create the decrypt package body

CREATE OR REPLACE PACKAGE BODY XXX_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 XXX_GET_PWD;
/

4) To get user password use below query

SELECT usr.user_name,get_pwd.decrypt((SELECT (SELECT 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 = '&USERNAME';

****************************நன்றி****************************