GRANT and REVOKE in SQL — a practical guide to SQL GRANT REVOKE with clear examples you can reuse in real projects.
SQL Tutorial Series (87/100). Prefer one article? Read the complete SQL tutorial.
Short description
Document who has what — privilege drift causes incidents.
Grant/Revoke (MySQL-style)
GRANT SELECT, INSERT, UPDATE ON shop.* TO 'app'@'localhost';
REVOKE DELETE ON shop.* FROM 'app'@'localhost';