title: Using spring-security: WebSecurityConfigurerAdapter: auth.jdbcAuthentication().usersByUsernameQuery: what should the query string look like?
body: <p>Using postgresql db with two tables to authenticate login ...(users and authorities)</p>
  
  <pre><code>CREATE TABLE users
  (
     username character(50) NOT NULL,
     password character(50) NOT NULL,
     enabled boolean NOT NULL,
     CONSTRAINT users_pkey PRIMARY KEY (username)
  )
  
  CREATE TABLE authorities
  (
      username character(50) NOT NULL,
      authority character(50) NOT NULL,
      CONSTRAINT fk_authorities_users FOREIGN KEY (username)
         REFERENCES users (username) MATCH SIMPLE
         ON UPDATE NO ACTION ON DELETE NO ACTION
  )
  </code></pre>
  
  <p>What am I doing wrong when I try to do the following?</p>
  
  <pre><code>registerAuthentication(AuthenticationManagerBuilder auth){
  
  auth.
        jdbcAuthentication()
              .dataSource(dataSource)
              .usersByUsernameQuery("select username,password,enabled 
                   from users where username = ?")
              .authoritiesByUsernameQuery("select username,authority from 
                   authorities where username = ?");
  
  }
  </code></pre>
  
  <p>Thanks</p>