How to grant a new user the same direct grant privilege as an existing user in sql

February 18, 2014 995 views
There is a new user that just joined our organization. I am trying to grant him the same direct grants privilege to the tables that the existing user has. The existing user has a ton of direct access privileges and it will take days if I had to do each grant one by one like: grant select,insert,delete,update on ttufiscal.pwrpwcm to XKY403. Is there a way of copying or inserting an existing user's privilege and granting it to a new user. Thanks
1 Answer
You can use mysqluserclone command from MySQL Utilities here:
Have another answer? Share your knowledge.