MariaDB [(none)]> CREATE ROLE DB_Admin;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO 'DB_Admin' WITH GRANT OPTION;
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [(none)]> SHOW GRANTS for 'DB_Admin';
|
+---------------------------------------------------------------+
|
| Grants for MariaDB_admin |
|
+---------------------------------------------------------------+
|
| GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO `MariaDB_admin` |
|
+---------------------------------------------------------------+
|
1 row in set (0.000 sec)
|