Permission to Joker Base

Asked

Viewed 9 times

1

I need to grant access to a particular user to all databases that start with abc (abc1, abc2, abcTeste, etc...), but new databases can be created and did not want to have to do this manually.

It would be something like:

GRANT SELECT, INSERT ON "abc%". * TO 'Mane'@'%';

Is there any way to do that?

Note: Mysql 8

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.