Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Authorization Schema

Otávio GoulartDec 19 2023

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;
Comments
Post Details
Added on Dec 19 2023
0 comments
87 views