How to retrieve SYSADMIN password in 11i/R12

STEP 1: Login to sqlplus APPS/<PASSWORD>

SQL> CREATE OR REPLACE PACKAGE APPS.XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXARTO_GET_PWD;
/
Package created.

SQL> CREATE OR REPLACE PACKAGE BODY APPS.XXARTO_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 XXARTO_GET_PWD;
 /
Package body created.

SQL> SELECT Usr.User_Name,
 Usr.Description,
 XXARTO_GET_PWD.Decrypt (
 (SELECT (SELECT XXARTO_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 welcome123 ->This is your sysadmin password

Post a Comment

0 Comments