Movie legend Sean Connery, who shot to stardom as British agent James Bond and went on to dominate the silver screen for four decades, has died aged 90.