For a specific MySQL user, is there a way to lock it so that it does not do the Data Export (DUMP) of a specific table, or the entire database?
I could not find a solution ... How do you deal with this?
Thank you!
Avoiding dump for MySQL users
0
asked by anonymous 11.02.2015 / 12:58
1 answer
1
A user can be created with read permission ( select ) specifically for certain tables and this does not imply giving access to the entire database for it.
According to this response from Server Fault, to perform dump it would also need at least lock tables permission.
However, when giving read permission to specific tables, do not be concerned if the user can dump these tables, after all he can simply execute a select on the entire table and save the results without any difficulties.
11.02.2015 / 14:56