UNEXPIRE_END_USER_ACCOUNT Procedure

46.145 UNEXPIRE_END_USER_ACCOUNT Procedure

This procedure makes expired end users accounts and the associated passwords usable, enabling an end user to log into developed applications.

Syntax

APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT (
    p_user_name IN VARCHAR2 );

Parameters

Table 46-124 UNEXPIRE_END_USER_ACCOUNT Parameters

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

Example

The following example renews (unexpires) an APEX end user account in the current workspace. This action specifically renews the account for use by end users to authenticate to developed applications and may also renew the account for use by developers or administrators to log into a workspace.

This procedure must be run by a user having administration privileges in the current workspace.

BEGIN
    FOR c1 IN (SELECT user_name from apex_users) LOOP
        APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT(p_user_name => c1.user_name);
        htp.p('End User Account:'||c1.user_name||' is now valid.');   
    END LOOP;
END;