2
Is there any way to free access to reading a specific database table for a third party system?
For example, I have a table called "customers" and a competing system has an efficient ticket issuing feature that can take advantage of this data and needs to consult my database to stay up to date and offer the resource. That’s possible?
I would not like to pass the ftp data of the system, and with a limited access of that would be enough...
0
You could create an 'external user' user and guarantee this only access to reading the tables, without having to copy them or make any other changes. This way the other (external) system will have access to the data you need and your bank will be safe, because the external access will not be able to edit anything or 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'@'%';
Browser other questions tagged php mysql oop
You are not signed in. Login or sign up in order to post.
Webservice was creating exactly for this. Search on the theme and the ways to create one, no doubt is bsm better than free access to your db
– Renato Tavares
Since WS would not be considered, you could create a database, a user with read-only permissions and make a copy of the tables you want. I think there is a way to automate the copies of the respective tables. It would not be an ideal solution but it is a sufficient solution.
– Filipe Moraes
So I thought about webserver logic although I never applied it to any solution. One detail is that the third system will generate the boletos, but somehow I have to be able to print/view on my site/system, up to this point I see what I can do, create a view, assemble a layout. The problem is to query the data, access database etc. Do you have any reference for me to read about? Thank you!
– Leatar