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, p_password IN VARCHAR2) RETURN BOOLEAN;
Parameters
Table 28-71 IS_LOGIN_PASSWORD_VALID Parameters
Parameter | Description |
---|---|
|
User name in account. |
|
Password to be compared with password stored in the account. |
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;