set lines 200 pages 50000
col USER_NAME for a10
col PASSWORD for a30
SELECT usr.user_name
,usr.user_id
,usr.employee_id
,get_pwd.decrypt((SELECT (SELECT get_pwd.decrypt(fnd_web_sec.get_guest_username_pwd,
usertable.encrypted_foundation_password)
FROM dual) AS apps_password
FROM apps.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 apps.fnd_user usr
WHERE usr.user_name IN (upper('&fnd_user_name'));
ORACLE EBS 查询用户名账号密码
未经允许不得转载:徐万新之路 » ORACLE EBS 查询用户名账号密码
相关推荐
表空间APPS_TS_ARCHIVE不足引发EBS登录闪退
[转]oracle EBS 基础100问
Oracle绑定sql执行计划
Oracle EBS 官方文档
Useful Articles for the Oracle E-Business Suite Technology Stack for Technical Consultant / DBA (Doc ID 828157.1)
Oracle EBS GL (General Ledger) 数据字典
Oracle EBS涉及的开发语言有哪些
Oracle E-Business Suite Release 12.2 with Oracle Database 23ai