Bug #78713 Allow wildcards in table names of GRANT statement
Submitted: 6 Oct 2015 8:04 Modified: 29 Nov 2017 10:52
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:5.6.26 OS:Any
Assigned to: CPU Architecture:Any
Tags: acl, grant, table, wildcard

[6 Oct 2015 8:04] Daniël van Eeden
I would like to be able to run something like this:

    GRANT SELECT ON 'mydb'.'history_%' TO 'archive_user'@'host.example.com';

This applies to some archive and sharding setups. For both it is common to grant on a per database level, but sometimes that's not enough

How to repeat:
See description
[15 Oct 2015 15:30] Pavel Katiushyn
+1 to this feature.
It is also interesting, if there are plans to implement roles?
[29 Nov 2017 10:52] Daniël van Eeden
That's in 8.0: https://dev.mysql.com/worklog/task/?id=988