Timeline for Wildcard in CREATE grant in MySQL
Current License: CC BY-SA 3.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 13, 2020 at 8:47 | comment | added | Yvan |
@fraff I would try to set large privileges (full table, all columns), and reduce the privileges one by one to find it out. I don't use such privileges, so I won't help much in the end. Don't forget to use flush privileges after each change!
|
|
Feb 11, 2020 at 14:44 | comment | added | fraff |
grant is created, I can see it with show grants for .. but user still can't create or frop table matching wildcard. I'm using mysql 5.7
|
|
Feb 11, 2020 at 14:04 | comment | added | Yvan |
@fraff it should be like this: GRANT CREATE ON `foo`.`bar%` TO ... . To add a backtick you should prefix it by an antislash: `\``
|
|
Feb 10, 2020 at 13:30 | comment | added | fraff | I tried, with backticks (I don't know how to add backticks in stackexchange comments without ruining indentation) on mysql5.7 but it didn't work. If you manage to do it please let me know, I'm still interested. | |
Feb 10, 2020 at 12:23 | comment | added | Yvan |
@fraff it should. But you've used single quotes ' instead of backtick ` . You can even go down to column privileges (see dev.mysql.com/doc/refman/8.0/en/…)
|
|
Feb 10, 2020 at 9:48 | comment | added | fraff |
Note it does not work at table level, GRANT CREATE ON 'foo'.'bar%' TO .. won't work
|
|
S Jun 13, 2016 at 15:58 | history | suggested | dr_ | CC BY-SA 3.0 |
Corrected wrong syntax; done other trivial changes because the edit must be 6 characters or more.
|
Jun 13, 2016 at 15:47 | vote | accept | dr_ | ||
Jun 13, 2016 at 15:47 | review | Suggested edits | |||
S Jun 13, 2016 at 15:58 | |||||
Jun 7, 2016 at 7:03 | history | answered | Yvan | CC BY-SA 3.0 |