This procedure resets the password for a named user and emails it in a message to the email address located for the named account in the current workspace. To execute this procedure, the current user must have administrative privilege in the workspace.
APEX_UTIL.RESET_PW( p_user IN VARCHAR2, p_msg IN VARCHAR2);
Table 35-86 RESET_PW Parameters
The user name of the user account.
Message text to be mailed to a user.
The following example shows how to use the
RESET_PW procedure to reset the password for the user 'FRANK'.
BEGIN APEX_UTIL.RESET_PW( p_user => 'FRANK', p_msg => 'Contact help desk at 555-1212 with questions'); END;