Disallow Update or delete in Oracle Apex through Process :
NB: CREATE PROCESS ON SAVE/"Apply Changes" Button:
VAL_UPDATE_PERMISSION
DECLARE
V_USER_TYPE NUMBER(10);
BEGIN
SELECT USERTYP INTO V_USER_TYPE FROM APPSUSERS WHERE LTRIM(RTRIM(USERNAME))=LTRIM(RTRIM(:APP_USER));
IF V_USER_TYPE =4 THEN
RETURN 'YOU ARE NOT ALLOWED TO UPDATE.';
END IF;
END;
NB: CREATE PROCESS ON DELETE Button:
VAL_DELETE_PERMISSION
DECLARE
V_USER_TYPE NUMBER(10);
BEGIN
SELECT USERTYP INTO V_USER_TYPE FROM APPSUSERS WHERE LTRIM(RTRIM(USERNAME))=LTRIM(RTRIM(:APP_USER));
IF V_USER_TYPE >=3 THEN
RETURN 'YOU ARE NOT ALLOWED TO DELETE.';
END IF;
END;
