Roles and Users in PostgreSQL: Why Everything Is (Only) a ROLE
PostgreSQL ROLE: users and roles are the same object. Mental model, GRANT, NOINHERIT and how to build a truly maintainable read-only account.
Privileges
3 tagged articles
PostgreSQL
Oracle
Users, Roles and Privileges in Oracle: Why GRANT ALL Is Never the Answer
Oracle security: redesigning the GRANT model with custom roles and Unified Audit, applying least privilege. Real case with copy-paste SQL.
MySQL
MySQL Users: Why 'mario' and 'mario'@'localhost' Are Not the Same Person
MySQL users and hosts: 'mario' and 'mario'@'localhost' are different entities. MySQL/MariaDB authentication model, common mistakes and correct GRANTs.