In my experience it's always coworkers on the lower end of the bell curve getting pissy. Nobody likes to be told he's just worth less.
And tbh I don't like salary transparency because it usually tightens the range of comp for a position. I've always been on the right side of the curve (getting promoted faster etc) so that would suck for me.