Users who only have select privileges on some of the columns in a table are unable to browse.
Is this something we can fix?
SQL to make reproducing easier:
GRANT USAGE ON *.* TO 'col'@'%';
GRANT SELECT (name, id), INSERT (name, id), UPDATE (name, id), REFERENCES (name, id) ON `test`.`col` TO 'col'@'%';
and to create the table:
CREATE TABLE `col` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;