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;
/

 

Recommended Posts

Start typing and press Enter to search