distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

smantscheff posted 9 months ago in General
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?
smantscheff posted 9 months ago
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.