I have the following code:
GRANT SELECT,INSERT,UPDATE ON db1.* TO ‘user’@example.com;
I am a beginner in mySQL, I was wondering if there is a method in which I can specific the privileges for every user in this domain network without having to type the above code for each user? %wildcard?
Also is there any method such as using a table where I can manage all the privileges of said users