Skip to content

Browse fails with users who have only column privileges for some columns #11922

@ibennetch

Description

@ibennetch

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;

Metadata

Metadata

Assignees

Labels

BugA problem or regression with an existing feature

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions