The intellectual property of the art which comprises the tattoo still belongs to the artist.
A second artist may not recreate that art in another medium (in this case, a texture for a video game) and then sell it for a profit; that's infringing on the original artist's intellectual property rights.