In today's post I will try to show you how to Change Password in Email Verification if you Forget Your Password in Oracle Apex. I hope you can easily use user authentication for your Oracle Apex application using the SQL code provided by me. How To Create Google Authentication in || User Authentication, Part-8
Some discussion about Change Password in Email Verification if you Forget Your Password in Oracle Apex, User Authentication, Part-9
"User Authorization" is an important issue for any web application. Without the use of "User Authorization", no application is complete.
Steps to Change Password in Email Verification if you Forget Your Password in Oracle Apex, User Authentication, Part-9
In today's post I will try to show you how to Change Password in Email Verification if you Forget Your Password in Oracle Apex. User Authentication
I hope you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.
1. Create a New page. Name- Forgot Password 2. Create Item Name- Email_Address 3. Create a Validation Name- Get Email Address
<![CDATA[
DECLARE
v_email NVARCHAR2 (50);
BEGIN
SELECT EMAIL_ADDRESS
INTO v_email
FROM MY_USERS
WHERE EMAIL_ADDRESS = :P38_EMAIL_ADDRESS;
RETURN TRUE;
EXCEPTION
WHEN OTHERS
THEN
RETURN FALSE;
END;
]]> 4. Create a New Processes Name- Send Email<![CDATA[
DECLARE
l_body_html CLOB;
v_name NVARCHAR2 (50);
v_code NVARCHAR2 (50);
v_email NVARCHAR2 (50);
BEGIN
SELECT EMAIL_ADDRESS, PASSWORD_RECOVERY_CODE
INTO v_email, v_code
FROM MY_USERS
WHERE EMAIL_ADDRESS = :P38_EMAIL_ADDRESS;
l_body_html :=
<body>
<div style="height:300px; margin-left: 15px; width: 100%;border: 1px solid rgb(167, 162, 162);box-shadow: 2px 2px 5px 2px rgb(216, 204, 203);">
<div style="background:#244283; height: 40px; width: 100%;color:#fff;">
<h2 style="margin-left:20px; margin-top: 0px; padding-top: 10px;">Account Verification Email</div>
</div>
<div style="height: 45px;margin: 20px;">
<p>Recover your password.<br />To verify your account please click the link below.</p>
<p><a href="https://apex.oracle.com/pls/apex/my_stock/r/demo-application-oracle-apex/email-verification?P39_EMAIL_ADDRESS=' || v_email || '">
<b> Verify Your account </b></a></p><br />
</div>
</div>
</body>
';
APEX_MAIL.SEND ( :P38_EMAIL_ADDRESS,
'no-reply@oraclelearner.com',
l_body_html,
l_body_html,
'Account Verification Email',
NULL,
NULL,
NULL);
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
]]> 5. Create a New page Name- Email Verification 6. Create a Region Name- Email Verification <![CDATA[
<div style = "text-align:center; color:red;">
<div style="font-size:1.3rem;">
<b>
Congratulation, Your account verification is done.<br />
<u> Change Your Password. </u>
</b>
</div>
</div>
]]> 7. Create Item Name-EMAIL_ADDRESS, NEW_PASSWORD, CONFIRM_NEW_PASSWORD 8. Create a Validations Name-New Password <![CDATA[
:P14_NEW_PASSWORD = :P14_CONFIRM_NEW_PASSWORD
]]> 9. Create a Buttons Name-Submit 10. Create a Processes Name-Update Processes <![CDATA[
BEGIN
UPDATE MY_USERS
SET PASSWORD = :P39_CONFIRM_NEW_PASSWORD,
pin = :P39_CONFIRM_NEW_PASSWORD
WHERE EMAIL_ADDRESS = :P39_EMAIL_ADDRESS;
APEX_APPLICATION.g_print_success_message :=
'Password Successfully Created';
EXCEPTION
WHEN OTHERS
THEN
APEX_APPLICATION.g_print_success_message := 'Password Not Updated';
END;
]]>
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. Demo Application
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 https://youtu.be/IajwZ5dp6Qc https://youtu.be/iRXsO0MTOuM https://youtu.be/IK3PjyWGQIA https://youtu.be/Ozoc4cpjBKY https://youtu.be/X407N_N2HNM https://youtu.be/n9W64qUoS1E https://youtu.be/X407N_N2HNM https://youtu.be/MPZQuraig7w Many thanks for visiting the site.
Then Enjoy......................... User Authentication Part-9
Change Password in Email Verify. User Authentication, Part-9
