Rutvik Prajapati

In the digital era, user authentication plays a vital role in web applications. A smooth and convenient authentication experience not only boosts user satisfaction but also simplifies the onboarding process. One effective method is integrating social sign-in options, enabling users to authenticate using their social media accounts. In this blog post, we will explore the process of implementing a Social Sign-In feature in an Oracle APEX Application, specifically focusing on authenticating users using their Google accounts. By integrating Google's authentication services into your APEX applications, you can offer your users a hassle-free login experience while leveraging the power of their Google credentials. Step 1: Register app and get Client Id and Client Secret from Google Cloud.  To implement social sign-in with Google in your Oracle APEX application, you need to register your app and obtain the Client ID and Client Secret from the Google Cloud Platform.  Here are the ste...

Recently, a new requirement came up to implement One Time Password (OTP) based authentication in Oracle APEX. In this, the user will enter his mobile number on the login page and will receive an OTP via SMS. The user will then enter the OTP on the login page and be able to authenticate himself in the APEX app.  When I started working on this requirement, first I identified all the steps that I need to implement for the solution.  Below are the steps that I followed: 1. Generate the OTP and temporarily store it in a database table. 2. Send the generated OTP to the user by integrating REST API to send the SMS 3. Validate the user entered OTP against the OTP that is stored in the table and authenticate the user. 4. Create a Custom Authentication Scheme. 5. Modify the login page. Let's understand each step in more detail. Step 1:  Generate the OTP and temporarily store it in a database table.  First, create a table to temporarily store the OTP for the validation. Here...