I performed schema authorization and associated it with page security. As a result, I am populating the application item 'user_nivel' through the return of the 'CONFERIR_SENHA' procedure. My objective is to use this 'nivel' value to determine user actions on the page, based on the permissions outlined in the table below. However, I encountered a limitation in setting up authorization conditions, specifically in specifying a schema like :USER_NIVEL < 4 (indicating that a user cannot delete data). Currently, I have only found the option to use the schema type to match an item value.


DECLARE
XNIVEL NUMBER;
BEGIN
CONFERIR_SENHA('R_FICHA', :APP_USER, :USER_ENTERPRISE, :USER_BRANCH, XNIVEL);
IF XNIVEL >= 0 THEN
:USER_NIVEL := XNIVEL;
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;