Steps to change APEX admin password using SQL,
1. Change the current schema to the one relevant for your APEX version
ALTER SESSION SET CURRENT_SCHEMA = APEX_050000;
2. Find the admin user in the WWV_FLOW_FND_USER table
COLUMN user_id Format 99999999999999999
COLUMN first_name FORMAT A20
COLUMN last_name FORMAT A20
COLUMN default_schema FORMAT A30
SELECT user_id,
first_name,
last_name,
default_schema
FROM wwv_flow_fnd_user
WHERE user_name = ‘ADMIN’
ORDER BY last_update_date DESC;
3. Update the password
UPDATE wwv_flow_fnd_user
SET web_password = ‘–Enter the Password you want–‘
WHERE user_name = ‘ADMIN’
AND user_id =1900277196314339;
COMMIT;
4. Unlock the user
BEGIN
WWV_FLOW_SECURITY.g_security_group_id := 10;
WWV_FLOW_FND_USER_API.unlock_account(‘ADMIN’);
COMMIT;
END;
/
