Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
ibennetch opened this issue Feb 6, 2016 · 7 comments
Closed

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

ibennetch opened this issue Feb 6, 2016 · 7 comments
Assignees
Labels
Milestone

Comments

@ibennetch
Copy link
Member

@ibennetch ibennetch commented Feb 6, 2016

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;
@ibennetch
Copy link
Member Author

@ibennetch ibennetch commented Feb 6, 2016

Loading

@madhuracj
Copy link
Contributor

@madhuracj madhuracj commented Feb 11, 2016

Given that only a very small fraction of users would have the problem, I am not sure checking column permission prior to generating the browse query is worth performance burden it adds to all the other users. Moreover, using a bookmark having the same name as the table with the appropriate browse query provides a workaround for this.

Loading

@madhuracj
Copy link
Contributor

@madhuracj madhuracj commented Feb 11, 2016

Loading

@madhuracj madhuracj removed their assignment Feb 11, 2016
@ibennetch ibennetch self-assigned this Feb 11, 2016
@ibennetch
Copy link
Member Author

@ibennetch ibennetch commented Feb 11, 2016

I don't see a good solution to this.

I'm interested in the bookmark workaround you mentioned and think it's acceptable to just document this as a known issue.

Loading

@madhuracj
Copy link
Contributor

@madhuracj madhuracj commented Feb 14, 2016

Addressed by PR #11938

Loading

@madhuracj madhuracj closed this Feb 14, 2016
@freshcalendars
Copy link

@freshcalendars freshcalendars commented Jan 7, 2019

You helped me solve a big problem. Thank you so much.

xoxo 😋

Loading

@Aboelfotoh83
Copy link

@Aboelfotoh83 Aboelfotoh83 commented Nov 7, 2019

Thank you for this solution.

Loading

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Nov 7, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
5 participants