- Get link
- X
- Other Apps
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;...