MariaDB [mysql]> create role role1;
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [mysql]> grant select on mysql.user to role1;
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [mysql]> create role role2;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [mysql]> grant role1 to role2;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [mysql]> revoke all, grant option from role2;
|
ERROR 1147 (42000): There is no such grant defined for user 'role2' on host '' on table 'user'
|
Error (Code 1147): There is no such grant defined for user 'role2' on host '' on table 'user'
|
Error (Code 1269): Can't revoke all privileges for one or more of the requested users
|
MariaDB [mysql]> show grants for role2;
|
+-------------------------------+
|
| Grants for role2 |
|
+-------------------------------+
|
| GRANT USAGE ON *.* TO 'role2' |
|
+-------------------------------+
|
|