foo.groovy

@Secured('IS_AUTHENTICATED_ANONYMOUSLY')
    def test() {
        respond UserRole.withCriteria {
            role {
                eq('authority', 'ROLE_COMPANY_ADMIN')
            }
        }
    }
    
    
    
    Message: ERROR: missing FROM-clause entry for table "role_alias1_"
  Position: 97
  
  
  Ultimate goal:
  
  def c = createCriteria()
        return c.list {
            role {
                eq('authority', 'ROLE_COMPANY_ADMIN')
            }
            user {
                eq('company', company)
            }
            projections {
                property ('user')
            }
        }