Saturday, March 03, 2018

MySQL 8.0 vs. MariaDB: Comparison of Database Roles

DZone Database Zone
MySQL 8.0 vs. MariaDB: Comparison of Database Roles
MySQL 8.0 vs. MariaDB: Comparison of Database Roles

In our last article, we had a look at MySQL 8 and mentioned new features available with it. However, some of those features are already in MariaDB and have been for a while. We will here compare database roles in both server dialects.

The Purpose of Database Roles

It’s common for numerous users within an organization to share the same database privileges. A role bundles a number of privileges together so that the DBA can set the privileges for a group of users all at once rather than having to set each user’s privileges individually.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...