By mayofadelu
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
You can use <b>mysqluserclone</b> command from MySQL Utilities here: <br>http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqluserclone.html
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.