Does Seeing God Cause Death to the Person?

Many ancient texts, including the Bible, note that seeing God brings death to the person. But then we also read of some who claim they saw God and lived to tell about it. What's going on? Which is it?