Change APEX Passwords using SQL

 

Change Password for ADMIN user for Internal Workspace

1. Make use of apxchpwd.sql script under APEX folder

2. Using SQL as follows,

alter session set current_schema=APEX_210100;
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;

  

 UPDATE wwv_flow_fnd_user SET web_password = 'NewPasswordIsHere' WHERE user_name = 'ADMIN' AND user_id =1582422781247865;

    

Unlock the user if it is Locked out
SELECT security_group_id FROM APEX_200200.wwv_flow_fnd_user WHERE user_name = 'ADMIN' ORDER BY last_update_date DESC;
 
  BEGIN
  WWV_FLOW_SECURITY.g_security_group_id := 10;
  WWV_FLOW_FND_USER_API.unlock_account('ADMIN');
  COMMIT;
  END;
                /

    

RESET PASSWORD FOR ANY APEX USER UNDER ANY WORKSPACE
SELECT user_id,first_name,last_name,default_schema
FROM wwv_flow_fnd_user WHERE user_name = 'DONDON'
ORDER BY last_update_date DESC;
 

UPDATE wwv_flow_fnd_user SET web_password = '123xyz'
WHERE user_name = 'DONDON' AND user_id =11647494203716240;
commit;

To Lock / Unlock an APEX User
SELECT to_char(security_group_id) FROM wwv_flow_fnd_user
WHERE user_name = 'DONDON' ORDER BY last_update_date DESC;


LOCK
BEGIN
WWV_FLOW_SECURITY.g_security_group_id := 9701765952338962;
WWV_FLOW_FND_USER_API.lock_account('DONDON');
COMMIT;
END;
/
Trying to attempt Login to APEX through user DONDON will fail with below error

UNLOCK
BEGIN
WWV_FLOW_SECURITY.g_security_group_id := 9701765952338962;
WWV_FLOW_FND_USER_API.unlock_account('DONDON');
COMMIT;
END;
    /