43.83 IS_LOGIN_PASSWORD_VALID Function
This function returns a Boolean result based on the validity of the password for a named user account in the current workspace. This function returns TRUE if the password matches and it returns FALSE if the password does not match.
Syntax
APEX_UTIL.IS_LOGIN_PASSWORD_VALID(
p_username IN VARCHAR2 DEFAULT NULL,
p_password IN VARCHAR2 DEFAULT NULL)
RETURN BOOLEAN;
Parameters
Table 43-71 IS_LOGIN_PASSWORD_VALID Parameters
Parameter | Description |
---|---|
|
User name in account. |
|
Password to be compared with password stored in the account. |
Returns
true
: The user credentials are valid.false
: The user credentials are invalid.null
: Credentials checking was delayed because of too many wrong combinations.
Example
The following example shows how to use the IS_LOGIN_PASSWORD_VALID
function to check if the user 'FRANK' has the password 'tiger'. TRUE
is returned if this is a valid password for 'FRANK', FALSE
is returned if not.
DECLARE
VAL BOOLEAN;
BEGIN
VAL := APEX_UTIL.IS_LOGIN_PASSWORD_VALID (
p_username=>'FRANK',
p_password=>'tiger');
END;
Parent topic: APEX_UTIL