I was experimenting with Profile Manager in Mountain Lion Server, and a while ago installed a profile that required a password to remove. And I forgot the password. Whoops. I had a profile I couldn’t remove from my own phone.
Fortunately, I tracked down the original profile by searching for a file ending in “.mobileconfig” on my Mac, and opened it in BBEdit. I looked for a key called “RemovalPassword”, and, voila, there it was — the password was visible. I removed the profile. Whew.