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
