I have a Java web app using Spring Security 5. I’m using MySQL as the database. The database table with users in it looks something like this: Spring Security requires me to give it two queries … one to get the users, and one to get the user’s roles. Typically the queries look like this: However, my users and roles