Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24289

show grants missing with grant

Details

    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

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24288 SHOW GRANTS output doesn't show the GRANT OPTION if ROLE is created with it.

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            anel Anel Husakovic added a comment - - edited

            Hi Serg here is a patch

            anel Anel Husakovic added a comment - - edited Hi Serg here is a patch
            anel Anel Husakovic added a comment -

            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.

            anel Anel Husakovic added a comment - 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.
            serg Sergei Golubchik added a comment -

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

            serg Sergei Golubchik added a comment - https://github.com/MariaDB/server/commit/f9bde99d0ce5f6db80ba5c8657d9e7fd2ad3d1ab is ok to push
            anel Anel Husakovic added a comment -

            Pushed to 10.2 with 1ccd1daaff50.
            Thanks Serg.

            anel Anel Husakovic added a comment - Pushed to 10.2 with 1ccd1daaff50 . Thanks Serg.

            People

              anel Anel Husakovic
              anel Anel Husakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.