Oracle Apex Social Sign in using Google / Gmail
Video Tutorial
In this tutorial you will learn how to configure Oracle Apex Social Sign in using Google / Gmail id.
Solution
1) Create an Application in your APEX workspace
Go to http://console.developers.google.com and login with your google account.
2) Create a new project (Click on below image)
3) Type Apex Social Authentication in Project Name anc press create button
4) Click on OAuth consent screen (from left side menu)
5) Select External and press Create button
6) On OAuth consent screen, Type APEX Social Authentication in Application name
7) Type apex.oracle.com in Authorized domains
8) Copy you Apex application home page link and paste in Application Homepage link
i.e https://apex.oracle.com/pls/apex/apexlessons/r/apex-google-authentication/home
9) Press Save button
10) Click on Credentials (from left menu)
11) Click on CREATE CREDENTIALS
See Example =======>
12) Select OAuth Client ID
13) Click on Web Application
14) Press Create button
15) Type any name in name field, i.e Apex Social Authentication
16) In Authorized redirect URIs type below url as shown in picture ===>
“https://apex.oracle.com/pls/apex/apex_authentication.callback”
17) Click on Save button
After click on Save button you will get Client ID and Client secret as shown in picture =====>
Save these Id’s we will use then later.
18) Now go to your APEX application’s “Shared Components” and click on “Web Credentials” under Security.
19) Click on Create button
20) Fill Web Credentials Attributes as shown below and then Click on Create button
Name : Google Authentication
Static Identifier: Google_Authentication
Authentication Type: OAuth2 Client Credentials Flow
OAuth Scope: Leave it blank
Client ID or Username: <Your Client ID> (Watch video in case of any confusion)
Client Secret or Password: <Your Client secret>
Verify Client Secret or Password: <Your Client secret>
21) Now go back to APEX application’s “Shared Components” and click on “Authentication Scheme” under Security.
22) Click on Create button to create new Authentication Scheme
23) Fill Authentication Scheme Attributes as shown below and then Click on Create button
Name: Google Authentication
Scheme Type: Social Sign-in
Credential Store: Google Authentication
Authentication Provider: Google
Scope: profile, email
Authentication URI Parameters: Leave it blank
Username Attribute: email
Convert username to Uppercase: No
Additional User Attributes: email, name
Congratulations 🙂 All Done
Now run the application and you should see
Hi, Great Job. Please help me How to click on the “Sign In withGoogle” button to be redirected to Gmail, complete the authentication from there, back to the application again.
L’echarpe est de bonne tournure, D’une peau souple sans couture; Mais sachez que vide n’etait, Car, en fille qui bien forgeait, Deux petits marteaux, a grand’ cure, Subtilement dame Nature Y mit, lorsque me la bailla. gucci sunglasses Bien plus, David lui-meme fut un des premiers a reprendre ce costume de l’ancien regime pour aller a la nouvelle cour du premier consul; on fit meme la remarque qu’il etait de ceux qui, ayant le mieux conserve la tradition, le portaient avec le plus d’aisance et de dignite.
wonderful points altogether, you just won a brand new reader. What might you suggest in regards to your submit that you simply made some days ago? Any certain?
Hi finally i got this blog. I was searching this sort of content from weeks back. thanks for sharing helpful short article, i am bookmarking your website for the very best and unique information. I wish to recommendDebatable Ape website for the most recent viral media information. Keep sharing!
hello im student
Magnificent items from you, man. I’ve remember your stuff previous to and you’re simply extremely magnificent. I actually like what you’ve acquired right here, certainly like what you’re saying and the way wherein you assert it. You make it enjoyable and you continue to take care of to stay it wise. I can not wait to learn far more from you. This is really a great web site.
It is in reality a great and useful piece of information. I am glad that you simply shared this useful info with us. Please stay us up to date like this. Thanks for sharing.
Did you try to make a switch between Google sign-in and APEX sign-in on login page?
You need to be a part of a contest for one of the best websites on the net. I most certainly will highly recommend this site!
Hello, I enjoy reading all of your post. I wanted to write a little comment to support you.
My spouse and I stumbled over here from a different website and thought I should check things out. I like what I see so now i am following you. Look forward to exploring your web page again.
Having read this I believed it was extremely informative. I appreciate you taking the time and energy to put this article together. I once again find myself personally spending way too much time both reading and posting comments. But so what, it was still worth it!
Hi there! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My website looks weird when browsing from my iphone4. I’m trying to find a template or plugin that might be able to correct this problem. If you have any suggestions, please share. Appreciate it!
I delight in, lead to I found exactly what I was looking for. You’ve ended my four day lengthy hunt! God Bless you man. Have a great day. Bye
Hello, i think that i saw you visited my weblog so i came to “return the favor”.I’m attempting to find things to enhance my website!I suppose its ok to use some of your ideas!!
Wow that was unusual. I just wrote an incredibly long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Anyhow, just wanted to say superb blog!
Incredible points. Solid arguments. Keep up the amazing work.
Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your blog? My blog site is in the exact same niche as yours and my users would truly benefit from some of the information you provide here. Please let me know if this okay with you. Thanks a lot!
Sure you can.
Very good post. I will be experiencing some of these issues as well..
Thanks designed for sharing such a good thought, article is good, thats why i have read it fully