28.32 UNLOCK_USER Procedure

This procedure unlocks an Oracle APEX workspace user account and optionally also changes the user's password.

Syntax

APEX_INSTANCE_ADMIN.UNLOCK_USER (
    p_workspace    IN  VARCHAR2,
    p_username     IN  VARCHAR2,
    p_password     IN  VARCHAR2 DEFAULT NULL );

Parameters

Parameter	Description
p_workspace	Workspace of the user.
p_username	Name of the user.
p_password	New password. If not set, only unlocks the account.

Example 1

The following example unlocks the user ADMIN in the instance administration workspace and changes the password.

BEGIN
    apex_instance_admin.unlock_user (
        p_workspace => 'INTERNAL',
        p_username  => 'ADMIN',
        p_password  => 'example password' );
    COMMIT;
END;

Example 2

The following example unlocks the user EXAMPLE_USER in SOME_WORKSPACE without updating the password.

BEGIN
    apex_instance_admin.unlock_user (
        p_workspace => 'SOME_WORKSPACE',
        p_username  => 'EXAMPLE_USER' );
    COMMIT;
END;