MariaDB Roles

on YouTube ↗19m

" summary

Roles implement the SQL standard and MariaDB adds DEFAULT ROLE so legacy apps gain role rights on connect; grants form a directed acyclic role graph (MariaDB forbids cycles, MySQL allows them). Effective privileges are precomputed at server startup and cached, with system storage in mysql.global_priv and edges in mysql.roles_mapping. Migration from MySQL 8.0 requires mariadb-dump using the --system and user switch to emit CREATE ROLE/USER statements, but some MySQL privileges need manual mapping.

AI-written summary · about

" chapters (8)

1. 0:00Introduction to MariaDB Roles
2. 3:54Role-based access example
3. 6:24Role hierarchies and inheritance
4. 8:46Performance and caching in roles
5. 11:09Least privilege principle with roles
6. 13:06Differences between MySQL and MariaDB
7. 16:38Migration from MySQL to MariaDB
8. 18:42Closing and Q&A

" related talks

• 34mUsing Roles and Partial Revokes To Improve Security in MySQL 8.0Alexander Rubin · Percona Live 2022
• 24mTips and Tricks for Migrating from Oracle to MariaDBAnders Karlsson · MariaDB OpenWorks 2023
• 41mMariaDB The New MySQLColin Charles · HighLoad++ 2012
• 53mMariaDB Server 10.2: The Complete GuideColin Charles · Percona Live Open Source Database Conference 2017
• 41mState of MySQL Security in 2021Peter Zaitsev · Data Con LA 2021
• 21mSwitching from MySQL/Percona to MariaDBPramod Mahto · MariaDB OpenWorks 2023
• 47mUntangling the Web of PostgreSQL PermissionsLætitia Avrot · PostgreSQL Conference Europe 2024
• 47mOn the past, present and future of Open Source databasesKaj Arnö · Shift Dev 2019