Is there any way to release read access from a specific database table to a third-party system?
For example, I have a table called "clients" and a competing system has an efficient ticketing feature that can take advantage of this data and need to consult my database to stay current and offer the feature. Is this possible?
I would not like to pass the system's ftp data, and with limited access this would be enough ...
You could create an'external user 'user and grant him only access to reading the tables, without having to copy them or make any other changes. In this way the other (external) system will have access to the data you need and your bank will be safe, because the sternum access will not be able to edit anything or to view the other tables.
The code below would solve:
CREATE USER 'usuarioexterno'@'%' IDENTIFIED BY 'senha';
GRANT SELECT ON banco_de_dados.tabela1 TO 'usuarioexterno'@'%';
GRANT SELECT ON banco_de_dados.tabela2 TO 'usuarioexterno'@'%';