登录/用户/密码

-- 检查用户名是否存在 以及密码是否失效

-- 如果帐户被锁定，则显示为INVALID

SELECT fu.encrypted_user_password FROM fnd_user fu WHERE fu.user_name = upper('chengweiyan');

-- 查询EBS登录用户名的密码

-- 可能查询不到

SELECT usr.user_name,
       cux_l_utl.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 = 'WANGLIN';

-- 用脚本修改用户密码

-- 修改成功了按钮才能提交，否则按钮不可提交

declare
  l_success boolean;
begin
  l_success := fnd_user_pkg.changepassword('JINSHAN', '1q2w3e4r');
  if l_success then
    dbms_output.put_line('Password Changed');
  else
    dbms_output.put_line('Something wrong');
  end if;
end;

来自为知笔记(Wiz)