[MDEV-5228] Incorrect message test on a failed attempt to revoke grants from a role - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Trivial
Resolution: Unresolved
Affects Version/s: 10.0.10, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.5, 10.6
Component/s: Authentication and Privilege System
Labels:

Description

The message incorrectly identifies the entity as a user, while it is a role:

MariaDB [test]> create role foo;

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> revoke all on bar.* from foo;

ERROR 1141 (42000): There is no such grant defined for user 'foo' on host ''

Since other errors seem to be able to distinguish between a user and a role, it might make sense fix this one too.

Attachments

Issue Links

relates to

MDEV-4397 Roles

Closed

MDEV-5164 Testing Roles

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2013-11-02 16:46

Elena Stepanova made changes - 2013-11-02 16:46

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

Elena Stepanova made changes - 2013-11-02 16:46

Link

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

Sergei Golubchik made changes - 2013-11-18 21:52

Fix Version/s		10.0.7 [ 14100 ]
Fix Version/s	10.0.6 [ 13202 ]

Sergei Golubchik made changes - 2013-12-28 17:50

Fix Version/s		10.0.8 [ 14200 ]
Fix Version/s	10.0.7 [ 14100 ]

Sergei Golubchik made changes - 2014-02-10 16:13

Fix Version/s		10.0.9 [ 14400 ]
Fix Version/s	10.0.8 [ 14200 ]

Sergei Golubchik made changes - 2014-03-09 22:02

Fix Version/s		10.0.10 [ 14500 ]
Fix Version/s	10.0.9 [ 14400 ]

Sergei Golubchik made changes - 2014-03-31 14:23

Fix Version/s		10.0.11 [ 15200 ]
Fix Version/s	10.0.10 [ 14500 ]

Elena Stepanova made changes - 2014-04-12 00:25

Affects Version/s

10.0.10 [ 14500 ]

Sergei Golubchik made changes - 2014-05-10 23:13

Fix Version/s		10.0.12 [ 15201 ]
Fix Version/s	10.0.11 [ 15200 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 29534 ]

MariaDB v2 [ 44615 ]

Sergei Golubchik made changes - 2014-06-16 13:27

Fix Version/s		10.0.13 [ 16000 ]
Fix Version/s	10.0.12 [ 15201 ]

Vicențiu Ciorbaru made changes - 2015-03-02 20:02

Assignee

Sergei Golubchik [ serg ]

Vicentiu Ciorbaru [ cvicentiu ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 44615 ]

MariaDB v3 [ 63969 ]

Igor Pashev added a comment - 2016-03-20 10:55 - edited

REVOKE ALL, GRANT OPTION FROM <role>; also fails if the <role> has no privileges granted.

Igor Pashev added a comment - 2016-03-20 10:55 - edited REVOKE ALL, GRANT OPTION FROM <role>; also fails if the <role> has no privileges granted.

Igor Pashev added a comment - 2016-03-20 11:01

It's even more complicated:

MariaDB [mysql]> create role role1;

Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]> grant select on mysql.user to role1;

Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]> create role role2;

Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> grant role1 to role2;

Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> revoke all, grant option from role2;

ERROR 1147 (42000): There is no such grant defined for user 'role2' on host '' on table 'user'

Error (Code 1147): There is no such grant defined for user 'role2' on host '' on table 'user'

Error (Code 1269): Can't revoke all privileges for one or more of the requested users

MariaDB [mysql]> show grants for role2;

+-------------------------------+

| Grants for role2              |

+-------------------------------+

| GRANT USAGE ON *.* TO 'role2' |

+-------------------------------+

Igor Pashev added a comment - 2016-03-20 11:01 It's even more complicated: MariaDB [mysql]> create role role1; Query OK, 0 rows affected (0.01 sec) MariaDB [mysql]> grant select on mysql.user to role1; Query OK, 0 rows affected (0.01 sec) MariaDB [mysql]> create role role2; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> grant role1 to role2; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> revoke all, grant option from role2; ERROR 1147 (42000): There is no such grant defined for user 'role2' on host '' on table 'user' Error (Code 1147): There is no such grant defined for user 'role2' on host '' on table 'user' Error (Code 1269): Can't revoke all privileges for one or more of the requested users MariaDB [mysql]> show grants for role2; +-------------------------------+ | Grants for role2 | +-------------------------------+ | GRANT USAGE ON *.* TO 'role2' | +-------------------------------+

Vicențiu Ciorbaru made changes - 2018-02-07 20:54

Labels

beginner-friendly

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

Workflow

MariaDB v3 [ 63969 ]

MariaDB v4 [ 139555 ]

Sergei Golubchik made changes - 2022-09-08 09:54

Fix Version/s

10.0 [ 16000 ]

Elena Stepanova made changes - 2022-10-22 14:14

Component/s		Authentication and Privilege System [ 13101 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]

Julien Fritsch made changes - 2023-03-06 08:44

Fix Version/s

10.7 [ 24805 ]

kevin cheng made changes - 2023-03-07 13:26

Comment

[ Hello, I have been able to reproduce the problem on version 10.4, and I am eager to solve it. Would it be possible for me to take on this task? Also, which branch should I use as the base branch? Thank you for your help. ]

Julien Fritsch made changes - 2023-04-27 14:22

Fix Version/s

10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-27 14:57

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:35

Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]

Nicholas Othieno added a comment - 2024-03-08 15:58

Fix for the issue submitted in https://github.com/MariaDB/server/pull/3114

Nicholas Othieno added a comment - 2024-03-08 15:58 Fix for the issue submitted in https://github.com/MariaDB/server/pull/3114

Julien Fritsch made changes - 2024-09-10 15:04

Fix Version/s

10.4 [ 22408 ]

Sergey Vojtovich made changes - 2025-01-29 19:00

Labels

beginner-friendly

beginner-friendly contribution

Vlad Radu made changes - 2025-02-06 07:19

Labels

beginner-friendly contribution

beginner-friendly contribution foundation

People

Assignee:: Vicențiu Ciorbaru

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2013-11-02 16:46

Updated:: 2025-02-06 07:19

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