That's a keeper! Thanks Razzak!
Albert
On 2016-02-27 10:00 AM, A. Razzak Memon wrote:
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
