APEX - change user's password

sqlplus / as sysdba

select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user');

-- Change schema name to whatever you want

ALTER SESSION SET CURRENT_SCHEMA = APEX_050100;

set lines 100

COLUMN user_id Format 99999999999999999

COLUMN user_name FORMAT A20

COLUMN default_schema FORMAT A30

-- Change user name to whatever you want

SELECT user_id,

user_name,

default_schema

FROM wwv_flow_fnd_user

WHERE user_name = 'ADMIN'

ORDER BY last_update_date DESC;

-- Change user name and user Id and <password> to whatever you want

UPDATE wwv_flow_fnd_user

SET web_password = '<password>'

WHERE user_name = 'ADMIN'

AND user_id = 1814258022160324;

COMMIT;

exit;

BEGIN

WWV_FLOW_SECURITY.g_security_group_id := 10;

WWV_FLOW_FND_USER_API.unlock_account('ADMIN');

COMMIT;

END;

/