Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.8
-
None
-
None
Description
One can create several roles at once:
MariaDB [test]> create role r1, r2; |
Query OK, 0 rows affected (0.01 sec) |
|
|
One can grant multiple privileges to multiple users at once:
MariaDB [test]> grant SELECT,INSERT on db.* to foo@localhost, bar@localhost; |
Query OK, 0 rows affected (0.00 sec) |
|
|
But one cannot grant multiple roles at once:
MariaDB [test]> grant r1, r2 to foo@localhost; |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' r2 to foo@localhost' at line 1 |
SQL standard seems to think that it should work.
