November 2017
Intermediate to advanced
542 pages
14h 24m
English
The JdbcUserDetailsManager class has three SQL queries that have a well-defined parameter and a set of returned columns. We must determine the SQL that we'll assign to each of these queries, based on the intended functionality. Each SQL query used by JdbcUserDetailsManager takes the username presented at login as its one and only parameter:
|
Namespace query attribute name |
Description |
Expected SQL columns |
|
users-by-username-query |
Returns one or more users matching the username; only the first user is used. |
Username (string) Password (string) Enabled (Boolean) |
|
authorities-by-username-query |
Returns one or more granted authorities directly provided to the user. Typically used when GBAC ... |
Read now
Unlock full access