[MDEV-14735] better matching order for grants - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.4.6
Component/s: Authentication and Privilege System
Labels:
None

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

MDEV-19899 Multiple matching grants no longer stacked

Closed

MXS-6495 Ensure that user account host pattern sort logic matches server

Open

relates to

MDEV-8269 Correct fix for Bug #20181776 :- ACCESS CONTROL DOESN'T MATCH MOST SPECIFIC HOST WHEN IT CONTAINS WILDCARD

Closed

MDEV-14732 mysql.db privileges evaluated on order of grants rather than hierarchically

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-12-21 08:52

Updated:: 2026-05-15 08:13

Resolved:: 2019-06-17 12:19

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1d 3h

Git Integration

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