At 10:29 AM 2/27/2016, Javier Valencia wrote:
A have created a user with a login and password and assigned privileges to access a limited number of tables on a development database. Is there an easy way to copy this information to the production database without having to redefine all the information from scratch?
Javier, If you have used the GRANT/REVOKE technique to assign PRIVILEGES, you can UNLOAD the database SCHEMA to a file and then look for the block of code starting with ..... SET USER PASSWORD FOR `xxxxx` TO `xxxx` GRANT .... Copy the code and then save to a file to be used in the production database. Note: You must use the OWNER privileges to UNLOAD/GRANT/REVOKE to perform such routines. Hope that provides you with some directions to handle such functions. Very Best R:egards, Razzak
