+ " from AUTH_USER_STATUS us,AUTH_USER_ROLE ur,AUTH_ROLE r"
+ " where us.id=ur.user_status_id and ur.role_id=r.id"
+ " and us.ref=? and us.scope_id=?";
public UserAuthDTO findByUsername(String username, String scopeId) {
ScopeDTO scopeDto = scopeConnector.findById(scopeId);
UserDTO userDto = userConnector.findByUsername(username,
scopeDto.getUserRepoRef());
Assert.notNull(userDto, "cannot find user by (" + username + ","
+ scopeId + ")");
return process(userDto, scopeDto, true);
}