• table
  • users
  • authorities
  • groups
  • group_members
  • group_authorities

        public static final String DEF_USERS_BY_USERNAME_QUERY =
                "SELECT username,password,enabled " +
                "FROM users " +
                "WHERE username = ?";
        public static final String DEF_AUTHORITIES_BY_USERNAME_QUERY =
                "SELECT username,authority " +
                "FROM authorities " +
                "WHERE username = ?";
        public static final String DEF_GROUP_AUTHORITIES_BY_USERNAME_QUERY =
                "SELECT g.id, g.group_name, ga.authority " +
                "FROM groups g, group_members gm, group_authorities ga " +
                "WHERE gm.username = ? " +
                "AND g.id = ga.group_id " +
                "AND g.id = gm.group_id";