• @[email protected]
    link
    fedilink
    14
    edit-2
    9 hours 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

    • @[email protected]
      link
      fedilink
      69 hours ago

      Isn’t that assuming you have access to doing arbitrary SQL queries on the database? Then you’d by definition have access to records you shouldn’t.

      • borari
        link
        fedilink
        1
        edit-2
        1 hour ago

        No. You can have control over specific parameters of an SQL query though. Look up insecure direct object reference vulnerabilities.

        Consider a website that uses the following URL to access the customer account page, by retrieving information from the back-end database: https://insecure-website.com/customer_account?customer_number=132355 Here, the customer number is used directly as a record index in queries that are performed on the back-end database. If no other controls are in place, an attacker can simply modify the customer_number value, bypassing access controls to view the records of other customers.