Requiring password before admin actions can be taken

Can you be much more specific? Give me real world examples of actual mistakes and problems?