How to reset Apex internal password with a script.

This is the script i use to reset Apex password in Apex version 4.x.

• Login to db as sysdba
• Check what verison is APEX user (mine case is 4.2 or APEX_040200)
• Execute Script

Script:

set define '&'

set verify off

alter session set current_schema = APEX_040200;

prompt ...changing password for ADMIN

begin

  wwv_flow_security.g_security_group_id := 10;

  wwv_flow_security.g_user := 'ADMIN';

  wwv_flow_security.g_import_in_progress := true;

  for c1 in (select user_id from wwv_flow_fnd_user

      where security_group_id = wwv_flow_security.g_security_group_id

      and user_name = wwv_flow_security.g_user) loop

     wwv_flow_fnd_user_api.edit_fnd_user(

       p_user_id => c1.user_id,

       p_user_name => wwv_flow_security.g_user,

       p_web_password => '&1',

       p_new_password => '&1');

  end loop;

  wwv_flow_security.g_import_in_progress := false;

end;

/

commit;

/