Query to get the password in Oracle

Query to get the password in Oracle

In this post , We will be discuss about Query to get the password in Oracle. I will share the detail sql query which help to get the password in oracle apps. I will share the complete sql query which help to extract oracle username and password in oracle apps.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 Query to get the password in Oracle.

Query to get the password in Oracle

Step by Step to get the password in Oracle

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