The docs explicitly say that wildcards are allowed when specifying database names in GRANT commands, but don't say anything about wildcards being allowed in table names. For example, in one large database I have table names that are grouped by function: security.ids_events secuirty.ids_correlations etc. My tests at giving a user rights to 'security.ids_%" (even by directly editing the tables_priv table) haven't worked out. Is this genuinely not possible or am I missing something?
