Create a Change Password Page In Oracle Apex? User Authorization,Part-3

How To Create a Change Password Page In Oracle Apex? User Authorization,Part-3.

In my previous video User Authorization Part-1, I tried to show you how to create user authentication table, sequence, package, trigger key.
I have tried to show you how to add Create New Account button in User Authorization Part-1.
Today's post How To Create a Change Password Page In Oracle Apex. Hopefully, you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.
How To Add Create New Account button in Apex|User Authorization,Part-2

Some discussion about Create a Change Password Page In Oracle Apex, User Authorization,Part-3.

"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 Create a Change Password Page In Oracle Apex, User Authorization,Part-3.

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, I will try to show you How To Create a Change Password Page In Oracle Apex. Hopefully, you can easily use user authentication for your Oracle Apex application using the SQL code provided by me. Hopefully, you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.

1. Create a New Blank page. >> Name- Change Password Page
2. Create a New Region. Name-Password Change.
3. Create a 5 items. Example- 1- USER_ID, 2-USUSERNAME, 3-OLD_PASSWORD, 4-NEW_PASSWORD, 5-CONFIRM_NEW_PASSWORD
4. Create a Button Name- Submit
5. Create a Dynamic Action Name- Get User Id Event >> Page Load Action >> Set Value >> Set Type- SQL Statement >> Paste the following code

                SELECT USER_ID
                  FROM MY_USERS0
                 WHERE UPPER (USERNAME) = :APP_USER Affected Elements >> Item ( s ) >> P2_USER_ID

6. Create Validating >> Name- Old Password >> Validation Type- Function Body (returning Boolean) >> PL/SQL Code >> Paste the following code

                BEGIN
                        RETURN acl.CUSTOM_AUTH (acl.GET_CURRENT_USER, :P14_OLD_PASSWORD);
                    END;

    Error Message >> Old Password does not match
    Display Location >> Inline With Field
    Associated Item >> :P2_OLD_PASSWORD
7. Create Validating. >> Name- New Password >> Validation Type- Expression >> PL/SQL Code >> Paste the following code

                 :P2_NEW_PASSWORD = :P2_CONFIRM_NEW_PASSWORD

    Error Message >> New Password doesn't match to each other!!!
    Display Location >> Inline With Field
    Associated Item >> :P2_NEW_PASSWORD
8. Create a Process >> Name- Update Processes, >> PL/SQL Code >> Paste the following code

                    UPDATE MY_USERS
                        SET PASSWORD = :P2_CONFIRM_NEW_PASSWORD, pin = :P2_CONFIRM_NEW_PASSWORD
                      WHERE UPPER (username) = UPPER ( :app_user) AND user_id = :P2_USER_ID;

When Button Pressed >> Submit

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.