How To unlock APEX admin without changing the password
Problem description:
You have locked your APEX administrator account by mistyping the account’s password too often. As other persons are also using the account, you don’t want to use the “apxchpwd”-script.
Problem resolution:
If you just want to unlock the account instead of completely resetting the password, you can use the following PL/SQL block to establish this task:
begin wwv_flow_security.g_security_group_id := <APEX_WORKSPACE_ID>; wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('<APEX_ACCOUNT_NAME>'); commit; end; /
Example:
- Query the id for the “INTERNAL” workspace:
SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = 'INTERNAL'; WORKSPACE_ID ------------ 10 SQL>
- Query the APEX schema’s name for your version:
SQL> select username from dba_users where username like 'APEX%' order by 1; USERNAME ------------------------------ APEX APEX_040200 APEX_PUBLIC_USER SQL>
- Switch your session to the APEX-schema:
SQL> alter session set current_schema = APEX_040200; Session altered. SQL>
- Unlock your ADMIN account with the following code:
SQL> begin 2 wwv_flow_security.g_security_group_id := 10; 3 wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN'); 4 commit; 5 end; 6 / PL/SQL procedure successfully completed. SQL>
Excelent! Runs fine!
Thanks!