There is probably still something in the background that is different. The error code is pretty clear in this that the username you apply for the authentication is not assigned to a group that the db allows queries from. Since the db connection itself is working I’m guessing this is on a schema/table level.
As such, it does not seem to be a KNIME issue to me.