How to Preview PDF into a Region in Oracle Apex

How to Create Custom and Dynamic Navigation Menu with PNG image and Icon | Oracle APEX || User Authentication

I have tried to show you how to add Create New Account button in User Authorization Part-2.
I have tried to show you how to create a Change Password Page In Oracle Apex in User Authorization Part-3.
I have tried to show how to use Reset Password Button In Oracle Apex in User Authorization Part-4.
In today's post How to Create Custom and Dynamic Navigation Menu with PNG image and Icon, I hope you can easily use user authentication for your Oracle Apex application using SQL code provided by me.
          How to use Reset Password Button In Oracle Apex. || User Authentication, Part-4

Some discussion about Custom and Dynamic Navigation Menu, User Authentication, Part-5.

"User Authorization" is an important issue for any web application. Without the use of "User Authorization", no application is complete.
I will try to show all the important things in the Oracle Apex application through a few parts, including user login according to "User Authorization", user role, user log, user menu usage. Hopefully, if you see all the parts related to "User Authorization", you can easily use "User Authorization" in Oracle Apex.

Steps to Custom and Dynamic Navigation Menu, User Authentication, Part-5

In my previous video User Authorization Part-1, I will try to show you how to create user authentication table, sequence, package, trigger key.
In today's post on how to create custom and dynamic menus with PNG images and icons, I hope you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.

1. Create all menu related tables....................

                    CREATE TABLE  "MENUS" 
                       (	"OID" NUMBER NOT NULL ENABLE, 
                    	"PARENT_OID" NUMBER, 
                    	"MENU_NAME" NVARCHAR2(100), 
                    	"STATUS" NVARCHAR2(1), 
                    	"DESCRIPTION" NVARCHAR2(200), 
                    	"SORT_BY" NUMBER
                    	 CONSTRAINT "MENUS_C01" CHECK (parent_oid <> oid) ENABLE, 
                    	 CONSTRAINT "MENUS_CON_PK" PRIMARY KEY ("OID")
                      USING INDEX  ENABLE
                       )  ENABLE ROW MOVEMENT
                    ALTER TABLE  "MENUS" ADD CONSTRAINT "MENUS_CON" FOREIGN KEY ("PARENT_OID")
                    	  REFERENCES  "MENUS" ("OID") ENABLE
                    CREATE SEQUENCE   "MENUS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1467 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
                

2. create a form and report page using the menu table. Name-Custom and Dynamic Menu.
3. Create a Process >>     Name- PRIMARY KEY, >> PL/SQL Code >>

                    SELECT MENUS_SEQ.NEXTVAL INTO :P16_OID FROM DUAL;
                

When Button Pressed >> Create.
4. Go To Shared Components >> Navigation >> Lists >> Create a New List
    Name- Dynamic Menu List. >> Paste the following code

                    SELECT LEVEL,
                        MENU_NAME
                            label,
                                DECODE (CONNECT_BY_ISLEAF,
                                          0, '',
                                          'f?p=&APP_ID.:' || TO_CHAR (MENU_LINK) || ':&SESSION.:::::')
                                      target,
                                  'YES:'
                                      is_current,
                                  NVL (icon_img, 'fa-apex-square')
                                      image,
                                  PARENT_OID
                             FROM MENUS
                            WHERE STATUS = 1
                       START WITH PARENT_OID IS NULL
                       CONNECT BY PRIOR OID = PARENT_OID
                ORDER SIBLINGS BY SORT_BY;
                

5. Go To Shared Components     >> User Interfaces >> Navigation Menu >>
    Navigation Menu List - Dynamic Menu List
    List Template- Top navigation Menu

If there is any problem with the SQL code provided by me then you can definitely let me know by mail or mobile number and comment. I must give you any SQL code. User Authorization

See My Demo Application.
            Url- Demo Application
            Username- demo, Pass- demo

Links to all the parts related to User Authorization will be given below.
1. User Authorization Schemes, Part-1 Video Url- https://youtu.be/vSdzwnkFDRs
2. Add Create New Account button on the login page, User Authorization, Part-2 Video Url- https://youtu.be/IajwZ5dp6Qc
3. Create a ChangePassword Page, User Authorization, Part-3 Video Url- https://youtu.be/iRXsO0MTOuM
4. Reset Password, User Authorization, Part-4 Video Url- https://youtu.be/IK3PjyWGQIA
5. Dynamic Navigation Menu, User Authorization, Part-5 Video Url- https://youtu.be/Ozoc4cpjBKY
6. Set Menu According To User Access Role, User Authorization Part-6 Video URL- https://youtu.be/X407N_N2HNM
7. Add Edit Button in Report According to User Access Role || Oracle APEX? User Authentication, Part-7.User Authorization Video URL- https://youtu.be/n9W64qUoS1E
8. Access google authentication in Oracle Apex | Google Authentication. User Authorization Video URL- https://youtu.be/kGMmvuG5Qs8
9. Change Password in Email Verification if you Forget Your Password. User Authorization Video URL- https://youtu.be/MPZQuraig7w

Hope you find this post helpful User Authorization. To see more about Oracle Apex User Authorization, you can visit my website.
You can also visit my youtube channel. I try my best to share my education with everyone. I will always try to give you something new. Please help by subscribing to my youtube channel.

Many thanks for visiting the site.

Then Enjoy.........................
Custom and Dynamic Navigation Menu, User Authentication, Part-5