how to create multi user oracle apex application with custome login using database table

how to create multi user oracle apex application


open your oracle application express click on


>app builder
> shred components
>authentication schemes
> create
> choose type custom
> authentication function click help icon
showing this scripts



>

create or replace function authenticate_ft_users
  (p_username in varchar2, p_password in varchar2)
return boolean
is
  l_user_name       ft_users.user_name%type    := upper(p_username);
  l_password        ft_users.password%type;
  l_hashed_password varchar2(1000);
  l_count           number;
begin

select count(*) into l_count from fit_users
  where user_name = l_user_name;

if l_count > 0 then
  l_hashed_password := ft_hash_password(l_user_name, p_password);
  select password into l_password from ft_users where user_name = l_user_name;
    if l_hashed_password = l_password then
    return true;
  else
    return false;
  end if;
  
else
  return false;
end if;
return true;
end authenticate_ft_users;




goto oracle apex sql scripts

> create new
> past (above  sql funcntion code )
> save and run it

>


if you found it error so comment