How to Assign Form to User (User Rights) in Oracle Apex | Mr Gactack

Опубликовано: 07 Июнь 2026
на канале: Mr Gactack

1,398

Hi guys in this video i am going to show you how to assign form to user (user rights) in Oracle Apex.

1) Create Table:-

Create Table MENU
(
MENU_ID varchar2(50),
MENU_NAME varchar2(50)
)

2) CREATE TRIGGER:-

CREATE TRIGGER for ID Auto Generate:-

CREATE TRIGGER GEN_MENU
BEFORE
insert on MENU
for each row
Declare
mVal Number;
Begin
Select nvl(max(to_number(substr(MENU_ID,6))),0) + 1 Into mVal From MENU;
:New.MENU_ID := 'MENU-'||mVal ;
End;

3) Add Column in User table:-

alter table USER_INFORMATION Add (MENU_RIGHTS VARCHAR2(3000))

4) Add Page Item MENU_RIGHTS On User Form
Type: List Manager

Qurey of MENU_RIGHTS:
Select Menu_Name||'-'||Menu_Id d,Menu_Id r from MENU

5) Create Region on Global Page
Custome Attribute: style="display:none;"

Add Page Item (P0_NAV_MENU) Then Hidden Page Item

6) Login Page:-

PLSQL Code:-

Select Menu_Rights Into :P0_NAV_MENU From USER_INFORMATION Where id = :P9999_USERNAME;

7) Create Report with Form for Menu Entry:

8) Share Component then Negation Menu then Desktop Nevigation Menu

Dashboard Form:
Expression: :P0_NAV_MENU Like '%MENU-1%'

Oracle Developer , Database , Oracle Apex , Oracle Apex Tutorial , assign form to user (user rights) , step by step , how , how to
--------------
if You enjoy this video please Like and Subscribe!

Channel By: Mr Gactack