Google Authentication In Apex, User Authentication, Part-8

How to Access google authentication in oracle apex Apps | Oracle Apex Social Google Authentication? User Authentication, Part-8

How to Access google authentication in oracle apex Apps || Oracle Apex Social Google Authentication? User Authentication


In today's post I will try to show you how to access google authentication in oracle apex. I hope you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.
Click on the link below to view the previous post and video Add Edit Button in Report According to User Access Role.
          Set Menu According To User Access Role? Oracle Apex || User Authentication, Part-6

Some discussion about Google Authentication In Apex, User Authentication, Part-8

"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.
In my previous video User Authorization Part-1, I tried to show you how to create user authentication tables, sequences, packages, trigger keys.
I have tried to show you how to add Create New Account button in User Authorization Part-2.
I tried to show you how to create a change password page in Oracle Apex in User Authorization Part-3.
I tried to show you how to use reset password button in Oracle Apex in User Authorization Part-4.
In User Authorization Part-5, I have tried to show you how to create custom and dynamic navigation menus with PNG images and icons.
In User Authorization Part-6, I have tried to show you how to create How to Set Menu According To User Access Role.
I have tried to show you how to create Add Edit Button in Report According to User Access Role in User Authorization Part-6.

Steps to Google Authentication In Apex, User Authentication, Part-8

In today's post I will try to show you how to access google authentication in oracle apex. I hope you can easily use user authentication for your Oracle Apex application using the SQL code provided by me.

1. First, log in to your Google Account.
2. Go to Google Cloud Platform.
          https://console.developers.google.com

    Click >> Credentials >> Create Credentials >> OAuth client ID
    Application Type- Web Application >> Name- Demo Applications Oracle Apex
    Authorized redirect URIs-           https://apex.oracle.com/pls/apex/apex_authentication.callback
    Click >> Create.
3. Go to your application
    Workspace Utilities >> All Workspace Utilities >> Web Credentials
    Create Web Credentials >>
    Name- Google Authentication
    Authentication Type- OAuth2 Client Credentials Flow
    Client ID or Username- Give your own information
    Client Secret or Password- Give your own information
    Click >> Create.
4. Go to your application Shared Components
    Authentication Schemes >> Click Create
    Create Scheme- Based on a pre-configured scheme from the gallery >> Next >>
    Name- Google Authentication
    Scheme Type- Social Sign-In
    Authentication Provider- Google     Click >> Create Authentication Schemes     Post-Logout URL- https://www.google.com/accounts/Logout
5. Go to your application Login Page
6. I went straight to my previously created report page.
    Create a Buttons, Name- Sign_In_Google
    Icon- fa-google
    Request- APEX_AUTHENTICATION=Google

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.........................
Google Authentication In Apex, User Authentication, Part-8

1 Comments

Hlo Sir

  1. Hello I am getting this error.
    The HTTP request to "https://accounts.google.com/.well-known/openid-configuration" failed.
    I have the certificates config in my data base, And form sql developer I am able to access that endpoint of the API. Do you know the possible cause?

    ReplyDelete
Previous Post Next Post