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

better matching order for grants

Details

    Description

      grants are sorted by get_sort(), the idea is that more specific grants gets sorted (and matched) before less specific. The historical implementation is rather naïve and does not handle many cases correctly.

      See linked bug reports for details.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19899 Multiple matching grants no longer stacked

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8269 Correct fix for Bug #20181776 :- ACCESS CONTROL DOESN'T MATCH MOST SPECIFIC HOST WHEN IT CONTAINS WILDCARD

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14732 mysql.db privileges evaluated on order of grants rather than hierarchically

          • Major - Major loss of function.
          • Closed

          Activity

            sanja Oleksandr Byelkin added a comment -

            OK to push, but please note (in the very beginning of description and well visible) that each d or h require 26 bit and u 1 bit of result. It is just for future use to avoid using "hdhd" by example of "huhu".

            Maybe add counter of shifts in debug version and ASSERT that it will not move over sizeof(ulonglong) but it is if you like the idea.

            sanja Oleksandr Byelkin added a comment - OK to push, but please note (in the very beginning of description and well visible) that each d or h require 26 bit and u 1 bit of result. It is just for future use to avoid using "hdhd" by example of "huhu". Maybe add counter of shifts in debug version and ASSERT that it will not move over sizeof(ulonglong) but it is if you like the idea.

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              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.