wildcards in grants are not supported
Open
enhancement
- Dominant language
- Go
- Stars
- 13.6k
- Forks
- 1.4k
- Avg merge
- 2h 31m
- Merged PRs (30d)
- 4
Description
We have a lot of databases which are named like "something_data_\". If I give these grants to ghost user :
```GRANT ALL PRIVILEGES ON `something\_data\_%`.* TO 'ghost'@'%'```
It fails with :
```ERROR User has insufficient privileges for migration. Needed: SUPER|REPLICATION CLIENT, REPLICATION SLAVE and ALL on `something_data_`.*```
If I connect with mysql client, the user can see the databases and make changes.
It's most probably in the way the permissions are checked in `gh-ost/go/logic/inspect.go` `validateGrants()`. I can't think of a non-ugly solution to check that though...
Contributor guide
Assessment
This issue has not been assessed yet.