问当用户是ORACLE APEX中的“最终用户”时隐藏维护页面

EN

create table users
  (username   varchar2(30),
   user_role  varchar2(20)
  );

insert into users (username, user_role)
  select 'Little', 'Admin'   from dual union all
  select 'Foot'  , 'EndUser' from dual;

create or replace function f_is_end_user (par_app_user in varchar2)
  return boolean
is
  l_one number(1);
begin
  select max(1) 
    into l_one
    from users
    where username = par_app_user
      and user_role = 'EndUser';
  return l_one = 1;
end;
/

SQL> begin
  2    dbms_output.put_line(case when f_is_end_user('&par_app_user') then 'it is end user'
  3                              else 'it is NOT end user'
  4                         end);
  5  end;
  6  /
Enter value for par_app_user: Little
it is NOT end user

PL/SQL procedure successfully completed.

SQL> /
Enter value for par_app_user: Foot
it is end user

PL/SQL procedure successfully completed.