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; @ Like Comment Share Subscribe And Press The Bill Icon... Facebook page: