What protection does Section 230 of the Communications Decency Act provide?

What protection does Section 230 of the Communications Decency Act provide? How does this act impact major tech companies such as Google and Facebook?