Oracle Apex 22.1.3 || HOW TO MAKE CUSTOM LOGIN AUTHENTICATION IN ORACLE APEX.

HOW TO MAKE CUSTOM LOGIN AUTHENTICATION IN ORACLE APEX.
#oracleapex #oracle #apex #sql #sqlqueries #plsql #oraclemessages #apex #oracleapex22.1.3
Code:
/*******Create Table******/
CREATE TABLE "LOGIN_USERS"
( "ID" NUMBER,
"USERNAME" VARCHAR2(50),
"PASSWORD" VARCHAR2(50),
CONSTRAINT "LOGIN_USERS_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
CREATE OR REPLACE EDITIONABLE TRIGGER "BI_LOGIN_USERS"
before insert on "LOGIN_USERS"
for each row
begin
if :NEW."ID" is null then
select "LOGIN_USERS_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_LOGIN_USERS" ENABLE
/
/*******Function Code******/
create or replace FUNCTION LOGIN_USERS_AUTH
(p_username in varchar2, p_password in varchar2)
return boolean
as
user_check varchar2(1);
begin
select 'x'
into user_check
from LOGIN_USERS
where upper(USERNAME) = upper(p_username) and PASSWORD= p_password;
apex_util.set_authentication_result(0);
return true;
exception when no_data_found then
apex_util.set_authentication_result(4);
return false;
end LOGIN_USERS_AUTH;
Share, Support, Subscribe!!!
Subscribe: / @techertzia798
instagram: / techertzia
About : Techertzia is a KZbin Channel, where you will find technological videos.

[@rijanmaharzan2958]

i tried the same thing, but as i log in it always shows I dont have permissions to access it can you please help?

[@vijaymuthu7566]

thanks you so much for this video can u make more videos regads apex, eagerly waiting

[@Eleyasriyad]

Thanks for the video. But after the user log in it ask for application access privilege. Which I need to provide mannually. How can I make it automatic like when a user open an account it can access the application like end user.

[@sumonchandranath6953]

signout button is not working.Please help me.

[@techertzia798]

just go to shared component->Navigation Bar List->Edit Sign out and make target type URL and set url target as &LOGOUT_URL.