* 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";
}}}