### Question:
UsersJdbcAuthzRepository extends AbstractJdbcRepository implements UsersAuthzRepository { @Override public List<String> findPermissionsByRoles(String rolesGuid) { String sql = " select p.permission from roles_permissions p where p.roles_id = (" + " select id from roles where guid = ? and archived = 0 )"; return this.jdbcTemplate.queryForList(sql, new Object[]{rolesGuid}, String.class); }  @Override List<Users> findUsersByUsername(String username); @Override List<Roles> findAvailableRolesList(); @Override Users findByUsername(String username); @Override int saveUsers(final Users users); @Override Roles findRolesByGuid(String guid); @Override void insertUserRoles(final int userId, final int rolesId); @Override List<Roles> findUsersRolesList(String usersGuid); @Override List<String> findPermissionsByRoles(String rolesGuid);  }### Answer:
@Test public void findPermissionsByRoles() throws Exception { final List<String> list = usersJdbcRepository.findPermissionsByRoles(GuidGenerator.generate()); assertNotNull(list); assertTrue(list.isEmpty()); }