IS_LOGIN_PASSWORD_VALID Function

Note:

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

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

Parameter	Description
`p_username`	User name in account.
`p_password`	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;