UNLOCK_ACCOUNT Procedure

59.154 UNLOCK_ACCOUNT Procedure

This procedure sets a user account status to unlocked. Must be run by an authenticated workspace administrator in a page request context.

Syntax

APEX_UTIL.UNLOCK_ACCOUNT (
    p_user_name IN VARCHAR2 )

Parameters

Parameter	Description
`p_user_name`	The user name of the user account.

Example

The following example unlocks all Oracle APEX accounts (workspace administrator, developer, or end user) in the current workspace.

BEGIN
    FOR c1 IN (SELECT user_name from apex_workspace_apex_users) LOOP
        APEX_UTIL.UNLOCK_ACCOUNT(p_user_name => c1.user_name);
        htp.p('User Account:'||c1.user_name||' is now unlocked.');    
    END LOOP;
END;