Use LOCAL_ONE for non-superuser auth queries

patch by Aleksey Yeschenko; reviewed by Jason Brown for CASSANDRA-7328