• asdfasdfasdf@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    12 days ago

    Just curious, but if SSNs were not recycled after death, would there be any reason not to use them as a primary key?

    • franzfurdinand@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      12 days ago

      They’re sequential, so the values above and below yours are valid SSNs of people born in the same hospital around the same time.

      This would make it trivially easy to get access to records you shouldn’t