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

Question

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

Answer 1

ricardo.parraga February 19, 2014

You can use mysqluserclone command from MySQL Utilities here:
http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqluserclone.html

Reply Report

Question

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