You see, Dwayne Johnson's grandfather Peter Maivia actually had a role in 1967's "You Only Live Twice," which starred Sean Connery in his fifth film as the British spy. The film was Maivia's only acting role during the peak of the Samoan-American's professional wrestling career (via IMDb). While only brief, he did have the opportunity to not only act opposite Connery, but also throw him through a Shoji Screen wall (via YouTube). Maivia is also credited as a stunt fight choreographer on the film, too.
Obviously, "The Rock" could easily play a similar, villainous role as his grandfather did. But as much as he would like to do that, it's the main role he's after. "I would like to follow in his footsteps and be the next Bond," he told Esquire. "I don't want to be a villain. You gotta be Bond," Johnson added.
As amazing as that would be, it's probably not going to happen. Especially since Barbara Broccoli, who has a major say in who plays Bond, has specified that he's got to be British. "He should be British, so British can mean any [ethnicity or race]," she told The Hollywood Reporter.