How to setup JDBC authentication with Spring Security from scratch - Java Brains

Let’s learn how to create a new Spring Security app that uses JDBC to connect to a database for user information. You’ll learn how to configure Spring Security to query your database to get users and authorities in order to authenticate your users, and you’ll also learn how to make it work with different schemas and data sources.

Default User Schema from documentation:

#JavaBrains #BrainBytes #HowTo #SpringSecurity #Spring #SpringBoot #Java #Tutorial

[sivanov]

Great tutorial, with it and the use of Chat GPT I was able to generate and run the app you created on Spring Boot 3.3.0. There, we don't extend the WebSecurityConfigurerAdapter, but rather add each configuration as a separate Bean to make it available for the Spring container to recognize and include in the app.

[najisolayman]

I recently watched your playlist on Spring Security, and I must say, it was one of the best educational resources I've come across on the topic. Your explanations were clear, concise, and easy to understand, and I appreciated the way you broke down the concepts into bite-sized pieces.
I just wanted to take a moment to thank you for creating such an informative and well-structured playlist. It's evident that you put a lot of time and effort into producing these videos, and it's greatly appreciated. Keep up the fantastic work!

[piters]

It will be great if you will talk about authentication using jwt for rest, and oauth

[apoorvnigam]

Yes, we always wait for Koushik's Thanks for your wonderful teaching

[kumarsaroj]

Well, the tutorial is very clear and explained with very simple examples which make even complicated concepts very easy to grasp. However, you didn't mention/explained following 2 things:
1. schema.sql and data.sql are standard file names, and are automatically picked by springboot from resources folder.
2. From above two sql files, we can get our custom schema (instead of default one). You kept the table and column name same as present in the default schema. So table and columns with different name are allowed ?
a. If not allowed, why did you mention that we can create our own schema?
b. If allowed, how do we tell springboot, which column to look into for username and which column for password, and same
goes to authorities/roles as well.

[togax]

Thank you so much for these amazing tutorials. You are one of my favorite teachers!

[bekirus]

One of the best java teachers on world wide web :) Your explantations are easy to understand ! Awesome!

[AbhishekAnandDas]

WebSecurityConfigurerAdapter has been deprecated in latest version of spring security. Can you make a video on latest version?

[narimo]

Why in the configuration we have roles `ADMIN` & `USER`.
However, in `data.sql` we have `ROLE_USER` & `ROLE_ADMIN`?
And everything keeps working fine.

[indranilgoswami]

Thanks Kuashik sir ..You are outstanding Teacher .. Thanks a lot .

[maheshdhavalshankh]

You explain very well sir!!!
Thanks for being on YouTube 🙏🏻🙏🏻🙏🏻

[MrNSundar]

Thank you..it would be great if you can come up with a tutorial for ldap authentication.

[francogb]

Thank you, but would be great if you can explain the usage with JWT. Keep it up!

[waheedkhan]

Hi Koushik, by any chance could you do a mini tutorial on integrating Spring Boot, Spring Security and Angular 7+ with typical real-world login, logout authentication flows and maybe some commentary about session\cookie management between the front-end and back-end?

[stevegathara]

Do you have a tutorial for this specific using the latest spring security documentation? i.e using version 3.1 and above

[gigel]

Hello Koushik. Maybe you already planned this, but could you show us how to get rid of the default html templates that spring security provides? Especially if you're building a rest service and don't want to use html at all.

[PramodKumar-humt]

Please do tutorials on Docker and Kubernetes

[anshumandas]

Please create the next video on Spring Boot jwt JPA authentication

[gormatikyan]

it is a very good tutorial but I have 2 questions.
1)In my example there is no difference between lowercase and uppercase for username
2)and there is authentication for url localhost:8080/user but there is not needed authentication for url localhost:8080/user/

[rajendrakumarsahoo]

First of all tons of thanks for these wonderful tutorials.But is it mandatory to have user and authority table relation as per spring boot standard ?