Unlock and Change Oracle APEX Password
Posted: Wed Dec 14, 2022 3:44 am
Here are steps to change your Oracle APEX admin password, APEX_220200 schema is your current schema as per your version of APEX,
Code: Select all
SELECT * FROM APEX_220200.WWV_FLOW_FND_USER A
WHERE ACCOUNT_LOCKED = 'Y';
BEGIN
APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10);
APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN');
UPDATE APEX_220200.WWV_FLOW_FND_USER SET WEB_PASSWORD = 'XXXXXXXXX'
WHERE USER_NAME = 'ADMIN';
COMMIT;
END;