$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #49

What happens to the analyst's UPDATE?

-- run as an admin
GRANT SELECT ON orders TO analyst;

-- later, run as analyst
UPDATE orders SET total = 0;
  1. Permission denied error
  2. It updates every row
  3. It runs as the admin
  4. It silently updates zero rows
GRANT SELECT allows reading only; modifying the table needs a separate UPDATE privilege.
Play SQL & Databases ▸