• asdfasdfasdf@lemmy.world
    link
    fedilink
    arrow-up
    6
    ·
    12 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@lemmy.dbzer0.com
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      5 hours 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.