\u6b64\u65b9\u6cd5\u5df2\u7ecf\u901a\u8fc7\u6d4b\u8bd5\uff0c\u4e14\u662f\u501f\u9274\u884c\u5185\u524d\u8f88\u7684\u65b9\u5f0f\uff0c\u8868\u793a\u611f\u8c22\uff0c\u540c\u65f6\u9700\u8981\u6ce8\u610f\uff0c\u6b64\u7a0b\u5e8f\u5728\u516c\u53f8\u6b63\u5f0f\u73af\u5883\u4e2d\u4e25\u7981\u4f7f\u7528\uff0c\u4f1a\u5e26\u6765\u5b89\u5168\u95ee\u9898\uff1a
\n—\u5c06\u4ee5\u4e0b\u4ee3\u7801\u7f16\u8bd1\u81f3\u76ee\u6807\u7cfb\u7edf—-
\nCREATE OR REPLACE PACKAGE cux_fnd_web_sec AUTHID CURRENT_USER AS
\nFUNCTION encrypt(key IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2;
\nFUNCTION decrypt(key IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2;
\nEND;
\n\/
\nCREATE OR REPLACE PACKAGE BODY cux_fnd_web_sec AS
\nFUNCTION encrypt(key IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2 AS
\nLANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WEBSessionManagerProc.encrypt(java.lang.String,java.lang.String) return java.lang.String’;
\nFUNCTION decrypt(key IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2 AS
\nLANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;
\nEND;
\n\/<\/p>\n
—\u67e5\u8be2\u51fa\u5bc6\u5319—<\/p>\n
SELECT user_name,
\ncux_fnd_web_sec.decrypt(upper(‘apps_uat_xx’), ENCRYPTED_USER_PASSWORD) pwd,
\nEND_DATE
\nFROM APPS.fnd_user
\nwhere user_name = upper(‘xxxx’)\uff1b<\/p>\n
SELECT usr.encrypted_user_password
\nFROM fnd_user usr
\nWHERE usr.user_name = ‘TEST’
\n—\u8fd4\u56de\u660e\u6587\uff0c\u5c06\u67e5\u8be2\u51fa\u7684\u7ed3\u679c\u4f5c\u4e3a\u6761\u4ef6\u5e26\u5165\u4e0b\u9762SQL\u547d\u4ee4—
\nSELECT cux_fnd_web_sec.decrypt(‘APPS’, ‘ZH226036FE93A20FAED89C4B92838B7C2A7F7133E613B028C482354D32F3C471AAB024794EAC70570FD2443717865F7BA824’)
\nFROM dual;
\n\u7ed3\u679c\u4e3a: TEST<\/p>\n
—\u6279\u91cf\u83b7\u53d6\uff0cORACLE\u4e3aapps\u7528\u6237\u5bc6\u7801
\ndeclare
\nl_info varchar2(10000);
\ncursor user_info is
\nSELECT usr.user_name, usr.encrypted_user_password
\nFROM fnd_user usr
\nwhere 1 = 1
\nand to_char(usr.start_date, ‘yyyy’) >= ‘2012’
\norder by usr.creation_date asc;
\nbegin
\nfor c1 in user_info loop
\nl_info := cux_fnd_web_sec.decrypt(‘ORACLE’, c1.encrypted_user_password);
\ndbms_output.put_line(‘\u7528\u6237\u540d\uff1a’ || c1.user_name || ‘ \u5bc6\u7801\uff1a’ || l_info);
\nend loop;
\nend;<\/p>\n
<\/p>\n
–\u540e\u53f0\u91cd\u7f6e\u5bc6\u7801
\nDECLARE
\nv_user_name \u00a0 \u00a0VARCHAR2(30) := UPPER(‘test01’);
\nv_new_password VARCHAR2(30) := ‘test01’;
\nv_status \u00a0 \u00a0 \u00a0 BOOLEAN;
\nBEGIN
\nv_status := fnd_user_pkg.ChangePassword(username \u00a0 \u00a0=> v_user_name,
\nnewpassword => v_new_password);
\nIF v_status = TRUE THEN
\ndbms_output.put_line(‘The password reset successfully for the User:’ ||
\nv_user_name);
\nCOMMIT;
\nELSE
\nDBMS_OUTPUT.put_line(‘Unable to reset password due to’ || SQLCODE || ‘ ‘ ||
\nSUBSTR(SQLERRM, 1, 100));
\nROLLBACK;
\nEND IF;
\nEND;<\/p>\n
–\u76f4\u63a5\u521d\u59cb\u5316<\/p>\n
DECLARE
\nP_USER_NAME FND_USER.USER_NAME%TYPE;
\nP_INIT_PASSWORD VARCHAR2(30);—\u521d\u59cb\u5316\u5bc6\u7801\uff0c\u975e\u52a0\u5bc6\u7684\u3002
\n—
\nl_change_flag VARCHAR2(10);
\nl_reason varchar2(2000);
\nBEGIN
\n—\u8f93\u5165\u53c2\u6570(\u7528\u6237\u540d\u548c\u521d\u59cb\u5316\u7684\u5bc6\u7801)
\nP_USER_NAME := ‘SYSADMIN’;
\nP_INIT_PASSWORD := ‘sinosoft123’;<\/p>\n
———
\n—\u5904\u7406–
\nL_change_FLAG := fnd_web_sec.change_password(P_USER_NAME,P_INIT_PASSWORD);<\/p>\n
IF L_change_FLAG = ‘Y’ THEN
\n— Bug 7016473 – During an administrative reset, set the last_logon_date to NULL
\n— instead of SYSDATE. last_logon_date should reflect the date the user last
\n— logged in successfully, not the date the user’s password was reset.
\n— This does not regress the fix for bug 4690441 because in fnd_web_sec.disable_user
\n— if last_logon_date is NULL, the last_update_date will be used which is the same
\n— date of the sysadmin reset, so the effect is the same.
\n—
\n— Reset password_date field to null to force password
\n— expiration the next time user logs on.
\n—
\nUPDATE FND_USER
\nSET last_logon_date= NULL
\n,password_date = NULL
\n–,LAST_UPDATE_DATE = SYSDATE
\n–,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
\nWHERE USER_NAME = P_USER_NAME;<\/p>\n
COMMIT;
\n—-
\nDBMS_OUTPUT.PUT_LINE(‘\u6210\u529f\u521d\u59cb\u5316\u7528\u6237(‘||P_USER_NAME||’)\u7684\u5bc6\u7801\u4e3a:’||P_INIT_PASSWORD);
\nELSE
\n—\u663e\u793a\u4e3a\u4ec0\u4e48\u4e0d\u53ef\u4ee5\u4fee\u6539
\nl_reason := fnd_message.get;
\nfnd_message.set_name(‘FND’, ‘FND_CHANGE_PASSWORD_FAILED’);
\nfnd_message.set_token(‘USER_NAME’, P_USER_NAME);
\nfnd_message.set_token(‘REASON’, l_reason);
\napp_exception.raise_exception;
\nEND IF;
\nEND;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6b64\u65b9\u6cd5\u5df2\u7ecf\u901a\u8fc7\u6d4b\u8bd5\uff0c\u4e14\u662f\u501f\u9274\u884c\u5185\u524d\u8f88\u7684\u65b9\u5f0f\uff0c\u8868\u793a\u611f\u8c22\uff0c\u540c\u65f6\u9700\u8981\u6ce8\u610f\uff0c\u6b64\u7a0b\u5e8f\u5728\u516c\u53f8\u6b63\u5f0f\u73af\u5883\u4e2d\u4e25\u7981\u4f7f\u7528\uff0c\u4f1a\u5e26\u6765\u5b89\u5168 … \u7ee7\u7eed\u9605\u8bfb\u5982\u4f55\u901a\u8fc7\u7a0b\u5e8f\u65b9\u5f0f\u89e3\u5bc6EBS\u7cfb\u7edf\u7528\u6237\u5bc6\u7801<\/span>