I have created a connection to an on prem sqlserver database using our gateway.
What intrigues me is that I have to use a fixed account and password in defining the connection. I would have expected that The credentials used will be taken from the current user of the power app. That way security could be imposed on the data delivered to powerapps.
Am i mistaken or is this something to be expected in the future?
I guess this is the expected behaviour. You control who can use the gateway and therefore, the service account used by the connection. I believe as the connection on prem is using a local account, then it can't use your cloud identity