| 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 | ||
[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
@Pavel: That's in 8.0: https://dev.mysql.com/worklog/task/?id=988
Description: 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