[MDEV-24289] show grants missing with grant Created: 2020-11-26  Updated: 2020-11-26  Resolved: 2020-11-26

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9

Type: Bug Priority: Major
Reporter: Anel Husakovic Assignee: Anel Husakovic
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-24288 SHOW GRANTS output doesn't show the G... Closed

 Description    

create role MariaDB_admin;
 
GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO 'MariaDB_admin' WITH GRANT OPTION;
 
SHOW GRANTS for 'MariaDB_admin';
 
Grants for MariaDB_admin
 
GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO 'MariaDB_admin



 Comments   
Comment by Anel Husakovic [ 2020-11-26 ]

Hi Serg here is a patch

Comment by Anel Husakovic [ 2020-11-26 ]

Results from test:

all suites

 
$ ./mysql-test/mtr --mem --max-test-fail=0 --parallel=4 --force
 
...
 
 
 
The servers were restarted 1351 times
 
Spent 9208.982 of 3290 seconds executing testcases
 
 
 
Completed: All 4002 tests were successful.
 
 
 
685 tests were skipped, 496 by the test itself.

Specifically main suite:

suite=main

 
$ ./mysql-test/mtr --mem --max-test-fail=0 --parallel=4 --force --suite=main
 
...
 
Completed: All 898 tests were successful.
 
 
 
57 tests were skipped, 38 by the test itself.

Buildbot result currently green and yellow (some workers didn't finish).
Will try to add befor each new review request some analysis as above for every reviewer.

Comment by Sergei Golubchik [ 2020-11-26 ]

https://github.com/MariaDB/server/commit/f9bde99d0ce5f6db80ba5c8657d9e7fd2ad3d1ab is ok to push

Comment by Anel Husakovic [ 2020-11-26 ]

Pushed to 10.2 with 1ccd1daaff50.
Thanks Serg.

Generated at Thu Feb 08 09:28:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.