spring security默认表

Attribute : users-by-username-query
An SQL statement to query a username, password, and enabled status given a username. Default  is "select username,password,enabled from users where username = ?"

Attribute : authorities-by-username-query
An SQL statement to query for a user's granted authorities given a username. The default is  "select username, authority from authorities where username = ?"

以后用户表为users，权限表为authorities，这样既可使用到默认的sql。