How can I limit table browsing to certain columns as specified in user privileges?

[expired user #5327]'s profile image [expired user #5327] posted 10 years ago in General Permalink
I've granted a user select privilege to some columns of a table and update privilege to exactly one of them. Now table browsing does not work because Heidi tries to select all columns instead of those for which the user has the select privilege. Is there a way how I can achieve that this user only sees some columns but still may values in another?
[expired user #5327]'s profile image [expired user #5327] posted 10 years ago Permalink
I found that I can define a view which contains only the desired columns so that it can be updated by the user with restricted privileges. So for the table the user has to have limited privileges, for the view unrestricted privileges, and also a SHOW VIEW privilege for the view so that Heidi won't stall. Is there an easier way, too?

Please login to leave a reply, or register at first.