Bug #76390 wrong privileges in SHOW FULL COLUMNS
Submitted: 19 Mar 2015 12:15 Modified: 19 Mar 2015 12:48
Reporter: Sergei Golubchik Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.5/5.6/5.7 OS:Any
Assigned to: CPU Architecture:Any

[19 Mar 2015 12:15] Sergei Golubchik 
Description:
see the test case below.
note that "SHOW FULL COLUMNS" only show "select", while "SHOW GRANTS" shows insert/update/delete. And the insert actually works.

How to repeat:
create database mysqltest1;
create table mysqltest1.t1 (a int, b year, c varchar(100));

grant select on *.* to u1@localhost;
grant select, insert, update, delete, lock tables, execute on mysqltest1.* to u1@localhost;

connect(u1, localhost, u1,,);
use mysqltest1;
show grants;
show full columns from t1;
insert t1 value (1,2,3);

connection default;

drop user u1@localhost;
drop database mysqltest1;
[19 Mar 2015 12:48] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[11 Oct 2016 8:19] Hans Maier 
What is the status on this bug? I cannot use Adminer with MySQL as long as this is not fixed. Thank you.