The longer you are prepared to wait, the more security you achieve.
I've never heard of it, but has there ever be insecure to wait more than 1 block? I've seen some cases of people who lost money, because two blocks were propagated and the block they had their transaction included got removed. Although, I have never heard it for 2 confirmations.