43.104 RESET_PW Procedure
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.
Syntax
APEX_UTIL.RESET_PW(
p_user IN VARCHAR2,
p_msg IN VARCHAR2);
Parameters
Table 43-88 RESET_PW Parameters
Parameter | Description |
---|---|
|
The user name of the user account. |
|
Message text to be mailed to a user. |
Example
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;
See Also:
Parent topic: APEX_UTIL