0
For a specific Mysql user, there is a way to block it from doing the Data Export (DUMP) of a specific table, or of the entire database?
I couldn’t find a solution... How you handle it?
Thank you!
1 answer
1
A user can be created with read permission (select) specifically for certain tables and this does not imply in giving access to the entire database for it.
According to this answer Server Fault, to perform the dump he would also need at least permission lock tables.
However, when giving read permission to specific tables, don’t be worried if the user can do the dump of these tables, after all it can simply perform a select in the entire table and save the results without difficulties.
Browser other questions tagged mysql mysqldump dump
You are not signed in. Login or sign up in order to post.
I guess it’s just a matter of the user not having access to the database, is that it? Because nothing would prevent the user from logging into the bank and dump the tables one by one.
– Rodrigo Rigotti
This is what @Rodrigorigotti said only the user does not have read table permission
– Adir Kuhn