Sean Connery is to reveal the truth behind his 007 screen legend in the autobiography he previously pledged never to write.