I’ve gotten locked out of my Oracle APEX workspace. It is hosted locally, not in the Cloud.
The reset password won’t help, as the account is tied to an email address of an employee who left.
The DBA has the credentials of an account of a different workspace.
Is there any procedure to reset this account’s password?
>Solution :
Do you have Database access?
If yes, you can see the Apex table (it’s schema named with the version like apex_210100) and under that, you will find WWV_FLOW_FND_USER table.
Update that table’s row with user_name = ‘youruser’ filtering.
i.e:
set ACCOUNT_LOCKED = 'N',FAILED_ACCESS_ATTEMPTS = 0, web_password = '12345',LAST_FAILED_LOGIN = NULL
where user_name = 'test@test.com';
commit;