Using mysql, how to restrict a user just to get the aggregated information (eg. sums, averages, count) of the table and only if the result of the number of record is greater than the threshold?
For example, if the threshold is 2, the following query should not be responded if only one supplier is living in London.
select count(*) from s where city = "london"
But this should not be responded.
select salary from s where city = "london"
Because if user knows in advance that there is only one who live in London, he can know his salary. I want to prevent that.