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;
- Permission denied error
- It updates every row
- It runs as the admin
- It silently updates zero rows
GRANT SELECT allows reading only; modifying the table needs a separate UPDATE privilege.