Sunday, July 28, 2019

APPS and Application User Password Find by PON_FORMS_UTIL_PVT.decrypt

SELECT PON_FORMS_UTIL_PVT.decrypt((SELECT fnd_web_sec.get_guest_username_pwd
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_PSWD
FROM dual;
=============================

SELECT PON_FORMS_UTIL_PVT.decrypt((SELECT PON_FORMS_UTIL_PVT.decrypt((SELECT fnd_web_sec.get_guest_username_pwd
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_PSWD
FROM dual)
,(SELECT encrypted_user_password
FROM fnd_user
WHERE USER_NAME=:P_APPLICATION_USER_NAME--'SYSADMIN'
)
) APPLICATION_USER_PSWD
FROM dual;
==================================================

No comments:

Post a Comment