Oracle Apex Desktop Navigation Menu User wise Authentications

CREATE TABLE ALOGIN
(OPRTR    VARCHAR2(10),
 URIGHTS   CHAR(1)
);


INSERT INTO ALOGIN VALUES ('D00001','1');
INSERT INTO ALOGIN VALUES ('D00002','1');
INSERT INTO ALOGIN VALUES ('D00003','1');
INSERT INTO ALOGIN VALUES ('D00004','1');

COMMIT;

Go to : > Shared Components > Navigation Menu > Desktop Navigation Menu > Click <> menu >
Go to : Conditions > Condition Type > (SQL Query Returns at least one row.) >

Write the following code at :

SELECT sys_context('APEX$SESSION', 'APP_USER') FROM DUAL
WHERE sys_context('APEX$SESSION', 'APP_USER') IN
(SELECT UPPER(OPRTR) FROM ALOGIN WHERE UPPER(OPRTR)='D00004')
OR sys_context('APEX$SESSION', 'APP_USER')='LIERP';


Reference 1st :       https://www.youtube.com/watch?v=J83jSqDwxgk