Find Oracle APPS User Password From Backend
/***********************************************************************************//* QUERY TO GET APPS USER PASSWORD FOR BACK END IN R12 */
/***********************************************************************************/
ALTER SESSION SET current_schema = apps;
SELECT (SELECT get_user_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 LIKE
(SELECT SUBSTR (fnd_web_sec.get_guest_username_pwd,
1,
INSTR (fnd_web_sec.get_guest_username_pwd, '/') - 1
)
FROM DUAL);
Query to get password for application user
SELECT usertable.user_name,
(SELECT get_user_pwd.decrypt
(UPPER
((SELECT (SELECT get_user_pwd.decrypt
(UPPER
((SELECT UPPER
(fnd_profile.VALUE
('Guest_User_Pwd'
)
)
FROM DUAL)
),
usertable.encrypted_foundation_password
)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE
UPPER
((SELECT SUBSTR
(fnd_profile.VALUE
('Guest_User_Pwd'),
1,
INSTR
(fnd_profile.VALUE
('Guest_User_Pwd'),
'/'
)
- 1
)
FROM DUAL)
))
),
usertable.encrypted_user_password
)
FROM DUAL) AS encrypted_user_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE UPPER ('&Username');
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.