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. Change Sysadminpassword
1.1 Fake with Shellpassword, can be changed by CPASs tool:
Fndcpass apps/appspwd 0 Y system/manager USER SYSADMIN Newspassword
Demonstrate:
-bash-3.2$ fndcpass Apps/apps 0 Y system/manager USER SYSADMIN welcome1
Log Filename:L5818900.log
Report Filename:O5818900.out
1.2 Fake with Appspassword, can be changed by fnd_user_pkg stored procedure:
Declare
L_flag Boolean;
Begin
L_flag = Fnd_user_pkg.change_password (' sysadmin ', ' newpassword ');
End
Demonstrate:
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 '
Ten END
11);
The END;
13/
L_flag = True
PL/SQL procedure successfully completed.
Sql> commit; --Don't forget to submit, otherwise it won't take effect.
Commit complete.
Sql>
2. Verify that the login password is correct
2.1 Validation via Fnd_user_pkg.validatelogin:
Demonstrate:
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 '
Ten END
11);
The END;
13/
L_flag = True
PL/SQL procedure successfully completed.
Sql>
2.2 Validation through the Fnd_web_sec.validate_login process:
Demonstrate:
sql> SELECT fnd_web_sec.validate_login (' sysadmin ', ' welcome2 ') from DUAL;
Fnd_web_sec. Validate_login (' SYSADMIN ', ' WELCOME2 ')
--------------------------------------------------------------------------------
Y
Sql>
----------------------
He has changed his own good.
--set serveroutput on DECLARE l_flag BOOLEAN; BEGIN
Set Serveroutput on-this is for output, run this line DECLARE L_flag BOOLEAN alone; BEGIN L_flag: = Fnd_user_pkg.changepassword (' sysadmin ', ' sysadmin '); Dbms_output.put_line ( ' l_flag = ' | | Case L_flag If true then ' true ' ELSE ' false ' END ); END; /