How to find SYSADMIN password in R12

 

This document describes how to find sysadmin password in R12 if we forget it.

Sometime we get the requirement to find the SYSADMIN password if we forget it or misplaced the document where we store the password information.

We can get the sysadmin password by using below query.

Step 1: Connect to the database as apps user.

Step 2: Run below query to find the password.

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 ='SYSADMIN';

Thanks for visiting the blog.