CHANGE_CURRENT_USER_PW Procedure

59.7 CHANGE_CURRENT_USER_PW Procedure

This procedure changes the password of the currently authenticated user.

Note:

This procedure operates on the native Oracle APEX user accounts repository and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.CHANGE_CURRENT_USER_PW (
    p_new_password  IN VARCHAR2 );

Parameters

Parameter	Description
`p_new_password`	The new password value in clear text.

Example

The following example demonstrates how to use the CHANGE_CURRENT_USER_PW procedure to change the password for the user who is currently authenticated.

BEGIN
    APEX_UTIL.CHANGE_CURRENT_USER_PW ('secret99');
END;