On 11.05.2018 18:01, Tatsuo Ishii wrote:
Plus checking username is neccessary (otherwise any user could retrieve a cache for a table lookup which is not permitted by other users).
as the tables a cached query operated on is known anyway -- it's needed to purge cache entries when table content changes -- schema and table level SELECT privileges can be checked ... I'm not fully sure about how MySQL handles its column level privileges in that respect, something I'd need to try out ... -- hartmut
