Councillor wants answers over 'wholly inappropriate' attempt