Cricket Australia has overturned the lifetime leadership ban it controversially imposed on David Warner in the wake of the "Sandpapergate" saga.