Wanting what you can't have?

Well the Rolling Stones wrote a song about it... We all want what we can't have. Why is that? What happens when you crave something your partner might not accept or will change their thoughts about you? Does it lose eroticisms after you get it?