SELECT usr.user_name,
APPS.get_pwd.decrypt
((SELECT (SELECT APPS.get_pwd.decrypt
(APPS.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
(APPS.fnd_web_sec.get_guest_username_pwd,
1,
INSTR
(APPS.fnd_web_sec.get_guest_username_pwd,
'/'
)
- 1
)
FROM DUAL)),
usr.encrypted_user_password
) PASSWORD
FROM fnd_user usr
WHERE usr.user_name = '&USER_NAME';
http://www.google.com/url?q=http%3A%2F%2Fwww.moshe-oracle.com%2Fsearch%2Flabel%2FDecrypt%2520SYSADMIN%2520and%2520APPS%2520Passwords%2520in%2520ORACLE&sa=D&sntz=1&usg=AFQjCNEjTAvnUV1O63xaXGpX59wg6wxQqw
ReplyDeletetks yours query , it,s work
ReplyDeleteThanks Pak Budi, you're welcome
Delete