本文共 1990 字，大约阅读时间需要 6 分钟。

Oracle EBS R12如何更改SYSADMIN的密码 测试环境： SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production CORE    11.1.0.7.0      Production TNS for Linux: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production SQL> select release_name from fnd_product_groups; RELEASE_NAME -------------------------------------------------- 12.1.1 SQL> 1.更改sysadmin密码 1.1 如果有shell密码，可通过CPASS工具进行更改： FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN newspassword 演示： -bash-3.2$ FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN welcome1 Log filename : L5818900.log Report filename : O5818900.out 1.2 如果有apps密码，可通过fnd_user_pkg存储过程进行更改： declare    l_flag  boolean; begin   l_flag = fnd_user_pkg.change_password('sysadmin','newpassword'); end; 演示： SQL> set serveroutput on SQL> DECLARE   2    l_flag   BOOLEAN;   3  BEGIN   4    l_flag := fnd_user_pkg.changepassword ('sysadmin', 'welcome2');   5    DBMS_OUTPUT.put_line (   'l_flag = '   6                          || CASE l_flag   7                               WHEN TRUE   8                                 THEN 'true'   9                               ELSE 'false'  10                             END  11                         );  12  END;  13  / l_flag = true PL/SQL procedure successfully completed. SQL> commit; --不要忘了提交，不然不生效 Commit complete. SQL> 2.验证登录密码是否正确 2.1 通过fnd_user_pkg.validatelogin进行验证： 演示： SQL> DECLARE   2    l_flag   BOOLEAN;   3  BEGIN   4    l_flag := fnd_user_pkg.validatelogin ('sysadmin', 'welcome2');   5    DBMS_OUTPUT.put_line (   'l_flag = '   6                          || CASE l_flag   7                               WHEN TRUE   8                                 THEN 'true'   9                               ELSE 'false'  10                             END  11                         );  12  END;  13  / l_flag = true PL/SQL procedure successfully completed. SQL> 2.2 通过fnd_web_sec.validate_login过程进行验证： 演示： SQL> SELECT fnd_web_sec.validate_login ('sysadmin', 'welcome2') FROM DUAL; FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','WELCOME2') -------------------------------------------------------------------------------- Y SQL> REF: 1. Oracle Apps R12 Change sysadmin password from sqlplus http://mtalmasri.blogspot.com/2011/01/oracle-apps-r12-change-sysadmin.html

转载地址：http://djtai.baihongyu.com/