dolthub
GRANT wildcard support
I am curious if the "GRANT SELECT ON db.table to [email protected].%" where xx are numbers works.
This does work in mysql and would be very useful in go-mysql-server. I have tried it and it doesn't seem to work?
Hey @joel-rieke, thanks for the feature request and sorry for the slow response. I don't believe we currently support wildcards in subsections of the hostname, but @Hydrocharged can confirm.
This would be a good feature to support. For future reference, here are the official MySQL docs on wildcard rules in host names.
Confirming that we do not yet support wildcards within subsections of the hostname. Right now we only support the entire hostname being a wildcard.
I know this is a little outside mysql standard, however, I forked and added support for cidr blocks so you can add GRANT to a cidr block. Maybe there's a way to support this using standard mysql grant syntax, but it wasn't that clear to me.