I have a usecase where the dremio service account used to connect to the datasource needs to pass the id of the user, so the underlying database can use prebuild security views of the datasource for a particular user.
I studied the code - every access has the user name.
JDBC has support for alternateUsernameAllowed which allows for overrite of connection with a different user.
Is it conceivable for Dremio server to send alternate credentials vs the service account user to the underlying database so security views already built can be utilized?