JUST UNLOCKING APEX ADMIN USER PASSWORD INSTEAD OF CHANGING IT

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:

begin

    wwv_flow_security.g_security_group_id := <APEX_WORKSPACE_ID>;

    wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('<APEX_ACCOUNT_NAME>');

    commit;

end;