I like to use an anti-seize compound, like Loc-Tite C5A, on both threaded and slip-fit connections, especially between dissimilar metals...like the steel and aluminum alloy of the BB axle and crank arms, to minimize the risk of corrosion/electrolytic galling and seizing. It's essential to clean the mating surfaces before assembly and use a light coating of lubricant/anti-seize compound. If you're careful about torquing you will not overtighten or undertighten the connection. I use C5A on my seatpost and barstem slip joints and have never had to deal with a seized (or loose) joint.

Of course you can have problems if the mating surfaces are sloppy to begin with, but that is another issue.