fix(auth): canonicalise sys_member.role at the write, and converge existing rows

fix(auth): canonicalise sys_member.role at the write, and converge existing rows #19026