[MDEV-35743] Routines not visible if granted indirectly - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5(EOL), 10.6, 10.11, 11.4
Fix Version/s: 10.11.19, 11.4.13, 11.8.9, 12.3.3, 13.0.2
Component/s: Authentication and Privilege System
Labels:
None

Bug Category:
Not for Release Notes
Sprint:
Q3/2026 Server Maintenance

Description

I was pleased to learn that privileges on views work successfully when granted indirectly (view granted to role B, role B granted to role A, I'm granted with A). However routines (procedures and functions) don't. I've got 1370 error while trying to use it. And also these aren't listed in information_schema.ROUTINES.
Has this functionality been implemented for routines?
My version: 11.4.2-MariaDB

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

eksp R_ADMIN role error case.sql
2025-01-16 09:53
0.8 kB
Tadas Balaišis

Issue Links

duplicates

MDEV-28743 Roles without grants are handled wrong

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Tadas Balaišis

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-01-02 07:29

Updated:: 2026-07-22 17:34

Resolved:: 2026-07-22 17:34

Time Tracking

Estimated:

Remaining:

Logged:

6d 10m

Git Integration

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