Unlock Apex admin account

You can find the lock accounts from the following query.

SELECT * FROM APEX_050000.WWV_FLOW_FND_USER A WHERE ACCOUNT_LOCKED = 'Y';

So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block.

BEGIN
   APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10);
   APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN');
   COMMIT;
END;

I hope this will help you 🙂

Leave a Reply

Your email address will not be published.