Oracle EBS 初始化用户密码
时间:2022-03-10 17:32
;
DECLARE
TYPE;
初始化密码,非加密的。
---
);
);
BEGIN
---;
;
---------
---);
THEN
-- Bug 7016473 - During an administrative reset, set the last_logon_date to NULL
-- instead of SYSDATE. last_logon_date should reflect the date the user last
-- logged in successfully, not the date the user‘s password was reset.
-- This does not regress the fix for bug 4690441 because in fnd_web_sec.disable_user
-- if last_logon_date is NULL, the last_update_date will be used which is the same
-- date of the sysadmin reset, so the effect is the same.
--
-- Reset password_date field to null to force password
-- expiration the next time user logs on.
--
NULL
NULL
--,LAST_UPDATE_DATE = SYSDATE
--,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
;
COMMIT;
----
);
ELSE
---显示为什么不可以修改
.get;
);
);
);
;
IF;
END;
Oracle EBS 初始化用户密码,布布扣,bubuko.com