Apex Report Restriction Based on User level


declare
val varchar2(100);
c1 number:=0;
begin
val := APEX_CUSTOM_AUTH.GET_USERNAME;
select count(*) into c1 from apex_workspace_apex_users where upper(user_name)=upper(val) and user_name!='ADMIN1';
if c1=1 then
return true;
else
return false;
end if;

end;