github / github/gh-ost

wildcards in grants are not supported

Open
#713 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.