How to Login App Using DB Table Users "Custom Auth" in Apex

Опубликовано: 07 Октябрь 2024
на канале: Knowledge Sign

2,217

#code
How to Login App Using DB Table Users "Custom Auth" in Apex

---------------------------
FUNCTION custom_auth (p_username in varchar2 , p_password in varchar2)
return Boolean
as
my_user NUMBER := 0;
BEGIN
SELECT 1 INTO my_user from TB_USERS
where EMP_CODE = :P9999_USERNAME
and (CURRENT_PASSWORD) = (:P9999_PASSWORD);
return true;
exception
when NO_DATA_FOUND then
RETURN false;
end custom_auth;
------------------------------------------------------------------------------------------------------

For More Videos,
Please Subscribe my Channel:
   / @knowledgesign22

Social Media links:
Facebook:
  / sharjeelrehmi

Emails:
[email protected]

Twitter:
  / sharjeelrehmi

queries:

Oracle APEX Custom Login
Oracle APEX Custom Login Page
How to Create Custom Authentication in Oracle APEX
Oracle APEX Custom Authentication
DB Users in Oracle APEX
How to Use User Authorization on Oracle APEX
How to Use User Authorization Schemes on Oracle APEX
User from Another Table
Login DB Users
Custom Auth Middleware JWT Verify
Oracle APEX Login Page Design
Oracle APEX Custom Template
How to Use User Authorization
Login APEX
Custom Authentication