[MDEV-23082] ER_TABLEACCESS_DENIED_ERROR error message is truncated, and inaccurately Created: 2020-07-03  Updated: 2020-10-06  Resolved: 2020-08-04

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Rucha Deodhar
Resolution: Fixed Votes: 0
Labels: upstream-fixed


 Description   

create user foo;
create database db;
create table db.t (a int);
 
--connect (con1,localhost,foo,,)
grant all on db.t to foo;

10.5 6cee9b195

MariaDB [test]> grant all on db.t to foo;
ERROR 1142 (42000): SELECT, INSERT, UPDATE, DELETE,  command denied to user 'foo'@'localhost' for table 't'

Note that the list of privilege is truncated.

Reproducible on all of 5.5-10.5.
Fixed in MySQL 5.6+.



 Comments   
Comment by Rucha Deodhar [ 2020-07-13 ]

Patch: https://github.com/MariaDB/server/commit/8a58299028f4b90aa4c1abcd9feb1ecb689ea813

Comment by Sergei Golubchik [ 2020-07-14 ]

please, specify in the commit comment where the limit of 110 comes from. Or is it just arbitrary number you've picked?

Comment by Rucha Deodhar [ 2020-07-14 ]

Changed commit message according to the last review. Patch: https://github.com/MariaDB/server/commit/ac1eb780cb5b86b5488fa22aefb5982194dc1389

Comment by Sergei Golubchik [ 2020-07-14 ]

can the list be longer than 110? in some other statement, perhaps?

Comment by Rucha Deodhar [ 2020-07-14 ]

serg Oh yes, right! Entire list of table privilege is longer than 110 characters. I'll make the changes. Thanks!

Comment by Rucha Deodhar [ 2020-07-18 ]

serg
Updated patch: https://github.com/MariaDB/server/commit/ee27ad74b3d32ba7feaa727aa4e20b692b0e1cca

Also added a test demonstrating more than 110 characters in the list of table privilege.

Comment by Sergei Golubchik [ 2020-07-30 ]

ok to push

Generated at Thu Feb 08 09:19:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.