I created a new user in Mysql with restricted permissions for only one VIEW. (GRANT ALL ON banco.view TO 'user' @ 'localhost')
When I try to connect to this user in DataStudio I get access denied. However, using the same user in any other tool like SequelPro for example, I can connect to a good one.
The question is: What permissions does DataStudio need to allow the connection.
If I give a GRANT ALL ON . there it works. But that's what I do not want to do because I need to restrict the user to just one VIEW.