[MDEV-26875] Wrong user in SET DEFAULT ROLE error - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.12
Fix Version/s: 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2
Component/s: Authentication and Privilege System
Labels:
None

Description

The error message for SET DEFAULT ROLE refers to the user performing the operation instead of the target user. This is misleading as the user giving the grant doesn't require the grant itself, only the target user.

Here's an example (and a test case) that reproduces the problem:

MariaDB [test]> create role test_role;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> create user test_user;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> set default role test_role for test_user;

ERROR 1959 (OP000): User `maxuser`@`127.0.0.1` has not been granted role `test_role`

MariaDB [test]> grant test_role to maxuser@127.0.0.1;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> set default role test_role for test_user;

ERROR 1959 (OP000): User `maxuser`@`127.0.0.1` has not been granted role `test_role`

MariaDB [test]> grant test_role to test_user;

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> set default role test_role for test_user;

Query OK, 0 rows affected (0.000 sec)

Attachments

Issue Links

duplicates

MDEV-27478 Misleading error message for SET DEFAULT ROLE

Closed

relates to

MDEV-22312 Bad error message for SET DEFAULT ROLE when user account is not granted the role

Closed

MDEV-26081 set role crashes when a hostname cannot be resolved

Closed

MDEV-6967 Wrong error code/message ER_INVALID_ROLE on setting a default role for non-existing user

Open

links to

PR 2362

Activity

Ascending order - Click to sort in descending order

markus makela created issue - 2021-10-21 08:50

markus makela made changes - 2021-10-21 08:50

Field	Original Value	New Value
Link		This issue relates to MDEV-6967 [ MDEV-6967 ]

Sergei Golubchik made changes - 2021-10-25 10:39

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]

Sergei Golubchik made changes - 2021-10-25 10:39

Assignee

Anel Husakovic [ anel ]

Anel Husakovic made changes - 2021-10-25 12:12

Link

This issue relates to ~~MDEV-22312~~ [ ~~MDEV-22312~~ ]

Anel Husakovic made changes - 2021-10-25 12:33

Link

This issue relates to ~~MDEV-26081~~ [ ~~MDEV-26081~~ ]

Anel Husakovic made changes - 2021-10-25 12:46

Status

Open [ 1 ]

Confirmed [ 10101 ]

Anel Husakovic made changes - 2021-10-25 12:47

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	Confirmed [ 10101 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 126462 ]

MariaDB v4 [ 143805 ]

Sergei Golubchik made changes - 2022-01-11 18:04

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2022-01-12 15:17

Link

This issue duplicates ~~MDEV-27478~~ [ ~~MDEV-27478~~ ]

Daniel Black made changes - 2022-01-20 01:58

Status

Stalled [ 10000 ]

In Testing [ 10301 ]

Anel Husakovic made changes - 2022-01-24 06:41

Status

In Testing [ 10301 ]

Stalled [ 10000 ]

Anel Husakovic made changes - 2022-01-24 06:41

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2022-01-28 19:25

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Anel Husakovic made changes - 2022-02-15 06:50

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2022-04-25 16:53

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Anel Husakovic made changes - 2022-06-14 07:04

Status

Stalled [ 10000 ]

Open [ 1 ]

Anel Husakovic made changes - 2022-12-07 13:21

Remote Link

This issue links to "PR 2362 (Web Link)" [ 34674 ]

Anel Husakovic made changes - 2022-12-07 13:21

Status

Open [ 1 ]

Confirmed [ 10101 ]

Anel Husakovic made changes - 2022-12-07 13:21

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	Confirmed [ 10101 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2022-12-25 18:11

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Anel Husakovic made changes - 2023-01-24 08:32

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Anel Husakovic made changes - 2023-01-27 15:13

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2023-07-21 07:27

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Anel Husakovic made changes - 2023-08-14 08:51

Assignee	Anel Husakovic [ anel ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2023-10-28 07:41

Assignee	Sergei Golubchik [ serg ]	Anel Husakovic [ anel ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Anel Husakovic made changes - 2023-10-30 17:41

Component/s		Authentication and Privilege System [ 13101 ]
Fix Version/s		10.5.23 [ 29012 ]
Fix Version/s		10.6.16 [ 29014 ]
Fix Version/s		10.10.7 [ 29018 ]
Fix Version/s		11.0.4 [ 29021 ]
Fix Version/s		11.1.3 [ 29023 ]
Fix Version/s		11.2.2 [ 29035 ]
Fix Version/s		11.3.1 [ 29416 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2023-10-30 17:41

Fix Version/s

10.11.6 [ 29020 ]

Daniel Bartholomew made changes - 2023-11-13 16:46

Fix Version/s		10.5.24 [ 29517 ]
Fix Version/s		10.6.17 [ 29518 ]
Fix Version/s		10.11.7 [ 29519 ]
Fix Version/s		11.0.5 [ 29520 ]
Fix Version/s		11.1.4 [ 29024 ]
Fix Version/s		11.2.3 [ 29521 ]
Fix Version/s		11.3.2 [ 29522 ]
Fix Version/s	10.5.23 [ 29012 ]
Fix Version/s	10.6.16 [ 29014 ]
Fix Version/s	10.10.7 [ 29018 ]
Fix Version/s	10.11.6 [ 29020 ]
Fix Version/s	11.0.4 [ 29021 ]
Fix Version/s	11.1.3 [ 29023 ]
Fix Version/s	11.2.2 [ 29035 ]
Fix Version/s	11.3.1 [ 29416 ]

People

Assignee:: Anel Husakovic

Reporter:: markus makela

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-10-21 08:50

Updated:: 2023-11-13 16:46

Resolved:: 2023-10-30 17:41

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration