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
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s