Custom Authentication and Authorization using ORACLE APEX
Custom Authentication and Authorization using ORACLE APEX
Authentication means confirming your own identity, whereas authorization means being allowed access to the system. In even more simpler terms authentication is the process of verifying oneself, while authorization is the process of verifying what you have access to.
FUNCTION user_aut (
p_username IN VARCHAR2, --User_Name
p_password IN VARCHAR2 -- Password
)
RETURN BOOLEAN
AS
lc_pwd_exit VARCHAR2 (1);
BEGIN
-- Validate whether the user exits or not
SELECT 'Y'
INTO lc_pwd_exit
FROM users
WHERE upper(LOG_IN) = UPPER (p_username) AND LOG_PAS = p_password and status='Y'
;
RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
RETURN FALSE;
END user_aut;
[email protected]
Like Comment Share Subscribe And Press The Bill Icon...
Facebook page: / oracle47
