The Ultimate Guide to High Availability with MariaDB

Comments - SHOW GRANTS

8 years, 5 months ago Cyril Ogana
Re: SHOW GRANTS
This comment has the status of 'removed' and can only be seen by you.

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

 
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.