Wednesday, July 17, 2013

Query To Get User Password in Oracle E-Business Suite Version 12


SELECT usr.user_name,
      APPS.get_pwd.decrypt
          ((SELECT (SELECT APPS.get_pwd.decrypt
                              (APPS.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
                                  (APPS.fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     INSTR
                                          (APPS.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';

3 comments:

  1. http://www.google.com/url?q=http%3A%2F%2Fwww.moshe-oracle.com%2Fsearch%2Flabel%2FDecrypt%2520SYSADMIN%2520and%2520APPS%2520Passwords%2520in%2520ORACLE&sa=D&sntz=1&usg=AFQjCNEjTAvnUV1O63xaXGpX59wg6wxQqw

    ReplyDelete