Comments - SHOW GRANTS
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Okay. Here is some more info: 1) Platform: - MariaDB 10.1.8 - Centos 6.7
2) Created Database: CREATE DATABASE dataservice; CREATE TABLE operations ( id INT(11) NOT NULL UNSIGNED PRIMARY KEY, description VARCHAR(45) NOT NULL 3) Create role: CREATE ROLE research; GRANT SHOW DATABASES ON *.* TO research; GRANT SELECT, INSERT, UPDATE ON dataservice.operations TO research; FLUSH PRIVILEGES;
4) Try to view the grants SET ROLE research; SHOW GRANTS FOR research;
(Result is: ERROR 1141 (42000): There is no such grant defined for user 'research' on host '%')
SHOW GRANTS; (This works)
5) NB: Using default my.ini settings, nothing has been updateda