Dynamic Navigation Menu And User Access Control | Oracle APEX

#dynamicmenu #oracleapex #oracleapexbangladesh

[ziadabuqasem]

hi sir thank you for your video and I have a question why you add admin user three times ? how to bring the menu and its submenu when give the user main menu how to bring sub menu to this user also ?

[karinacandido]

Hi, thank you for shared this video with us! It is so helpful.

The query used in the List Query page

SELECT level,
name label,
target,
'NO' as is_current,
icon as image
from CUSTOM_MENU
WHERE ID IN ( select A.MENU FROM USER_ACCESS A WHERE USERNAME=:APP_USER)
start with PID IS NULL
CONNECT BY PRIOR ID=PID
order siblings by ID
;

[Gamefun-xnfx]

But when you add filter to check which pages are against of admin and you give access custom menu page access to admin so only custom menu button shows but his sub menu not shows?

[md.selimhossain]

আরেকটি সুন্দর ভিডিওর জন্য আপনাকে ধন্যবাদ।
একটি প্রশ্ন, Apex এ কি Trigger use করা যায়? হলে এর উপর একটি ভিডিও হলে ভালো হয়।

[mbparif]

Assalam o Aalikum!.
Sir Thanks Alot.
But 1 Question?
Sir i allow to user only form but whene i press create button then page redirect on report.
i do not want to go user report side.
what can i do for fix it?

[zongkhan]

Hi sir your work is unique. Can u give a tip how to create approval hierarchy? If an employee submit a request then based on request type (leave or Loan) it should be redirected to either HR or Finance department

[hetshah]

when i am adding where clause list is disappering write a blog in these topic

[bdnews]

:APP_USER variable is not working in 19.2 version. what can I do now?

[danishayder]

Can you share this app . I will be more helpful for us.

[techgreek]

one suggestion
please include the source code in the description so it will easy to use it

[ashrafnobel]

Thanks for the video. Can you make video reset user password on oracle apex, Please