I'd recommend setting up group roles (roles which cannot login) to grant
your various permission sets to, and then add users to the appropriate
groups, using permission inheritence. Then any grants/revokes you make in
the future to the groups automatically apply to the users. You may wish to
divi
I have created a user(user1), and with this user I created a db1 and some tables, some functions in it.Now I want to create another user(user2), and I want the two users can access everything in the database db1,like GRANT ALL ON DB1 TO 'USER'@'%' ... in MYSQL.For example:1, The two users can acces